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 with PHP?
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.
2 matches
Mail list logo