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