Sounds like your first column is set to unique key. But why are you
trying to enter the exact same info again anyway. That's not how it's
usually done. Something should be different in each row, or what's the
point?
Jordan Sparks
-----Original Message-----
From: Duncan Paul Attard [mailto:duncanatt@stripped]
Sent: Thursday, November 11, 2004 6: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.
