|
Posted by toylet on 01/04/06 04:04
> Here's one thought ..... ascii (97) is the letter "a" .... is it
> possible that the ascii (65) "A" was interpreted as lowercase thus
> creating a duplicate primary key? Or your DBMS doesn't make a
> distinction between upper or lower case.
You are correct. I compiled mysql and php from source tar-ball. I dind'
tknow that the default character set and collate are case-insensitive.
It's fixed after I set the character set to
latin1" and collate to "latin1_bin" in /etc/my.cnf.
--
.~. Might, Courage, Vision. SINCERITY. http://www.linux-sxs.org
/ v \
/( _ )\ (Fedora Core 4) Linux 2.6.14-1.1653_FC4
^ ^ 10:03:01 up 16 days 1:00 load average: 0.00 0.00 0.00
Navigation:
[Reply to this message]
|