Re: newbie question about storing big5 codes into mysql-5.0.24a
| From: | Tijnema ! | Date: | Sat, 24 Mar 2007 10:05:52 +0000 |
| Subject: | Re: newbie question about storing big5 codes into mysql-5.0.24a | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-251274@lists.php.net to get a copy of this message | ||
On 3/24/07, Man-wai Chang <toylet.toylet@gmail.com> 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. 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