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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
