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

2007-03-25 Thread Jochem Maas
Man-wai Chang wrote: >> queries in the command-line MySQL client. If it works there but not >> through mysqli_query() then you might have a case for asking here. > > For the 13081 chinese alphabets I tried, only 1 one failed, and it's > 0x9f54. mysqli_query() should have escaped the string for me.

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

2007-03-25 Thread Man-wai Chang
> queries in the command-line MySQL client. If it works there but not > through mysqli_query() then you might have a case for asking here. For the 13081 chinese alphabets I tried, only 1 one failed, and it's 0x9f54. mysqli_query() should have escaped the string for me. So ... I suppose most PHP p

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

2007-03-25 Thread Stut
Man-wai Chang 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 does this has to do

[PHP] Re: 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? > What does this has to do with PHP? > First of all I