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? >> First of all I don't see any PHP code, and second this is an error in >> your SQL query, so you should be on the MySQL list. > > I used mysqli_query() to send the SQL. How could I make it work? That really doesn't make this question PHP-related. You really do need to ask on a MySQL mailing list. This has nothing to do with PHP, and you're more likely to get a useful answer from a MySQL-specific list. If you really want to try and justify asking this question here, try the 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. -Stut -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
