newbie question about storing big5 codes into mysql-5.0.24a
| From: | Man-wai Chang | Date: | Sat, 24 Mar 2007 07:49:25 +0000 |
| Subject: | newbie question about storing big5 codes into mysql-5.0.24a | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-251270@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?
--
.~. 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