These two records appear to be identical. What am I missing?
-----Original Message-----
From: Duncan Paul Attard [mailto:duncanatt@stripped]
Sent: Thursday, November 11, 2004 8:06 AM
To: dotnet@stripped
Subject: Problem when inserting unicode records
I'm having a problem when inserting the following records...
insert into kbase values ('archaic', '', 'reject')
and,
insert into kbase values ('archaic', '', 'reject')
The problem is that the first record is being inserted, but when I try to
insert the second record, I get an error saying:
[test] ERROR 1062: Duplicate entry 'archaic' for key 1
although the first record's keyfield is 'archaic' and not 'archaic'.
I am using MySql Connector/NET beta 2 and C#.
Thanks in advance for your help, and looking foward to hearing
from you.
Duncan Paul Attard.
