[PHP] newbie question about storing big5 codes into mysql-5.0.24a

2007-03-24 Thread Man-wai Chang
create table temp ( big5 char(2) ) character set big5 collate big5_bin; insert into temp ( big5 ) values ( 0x9f54 ); insert into temp ( big5 ) values ( 0x9f53 ); The 2nd query will report duplicated key. How should I fix the problem? -- .~. Might, Courage, Vision, SINCERITY.

Re: [PHP] newbie question about storing big5 codes into mysql-5.0.24a

2007-03-24 Thread Tijnema !
On 3/24/07, Man-wai Chang [EMAIL PROTECTED] wrote: create table temp ( big5 char(2) ) character set big5 collate big5_bin; insert into temp ( big5 ) values ( 0x9f54 ); insert into temp ( big5 ) values ( 0x9f53 ); The 2nd query will report duplicated key. How should I fix the problem? What

Re: [PHP] newbie question about storing big5 codes into mysql-5.0.24a

2007-03-24 Thread Jochem Maas
Tijnema ! wrote: On 3/24/07, Man-wai Chang [EMAIL PROTECTED] wrote: create table temp ( big5 char(2) ) character set big5 collate big5_bin; insert into temp ( big5 ) values ( 0x9f54 ); insert into temp ( big5 ) values ( 0x9f53 ); The 2nd query will report duplicated key. How should I fix