Tijnema ! wrote: > On 3/24/07, Man-wai Chang <toylet.toylet@xxxxxxxxx> 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. and thirdly why not use unicode??? > > Tijnema >> >> -- >> .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org >> / v \ Simplicity is Beauty! May the Force and Farce be with you! >> /( _ )\ (Ubuntu 6.10) Linux 2.6.20.4 >> ^ ^ 15:46:01 up 2:58 1 user load average: 2.32 1.73 1.48 >> news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php