Re: newbie question about storing big5 codes into mysql-5.0.24a
| From: | Man-wai Chang | Date: | Sun, 25 Mar 2007 06:44:00 +0000 |
| Subject: | Re: newbie question about storing big5 codes into mysql-5.0.24a | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-251316@lists.php.net to get a copy of this message | ||
>> 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?
--
.~. 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
^ ^ 14:43:01 up 1 day 1:55 0 users load average: 1.01 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk