List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:November 11 2004 3:39pm
Subject:RE: Problem when inserting unicode records
View as plain text  
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.

Thread
Problem when inserting unicode recordsDuncan Paul Attard11 Nov
  • RE: Problem when inserting unicode recordsReggie Burnett11 Nov
  • RE: Problem when inserting unicode recordsJordan Sparks11 Nov
RE: Problem when inserting unicode recordsReggie Burnett11 Nov
RE: Problem when inserting unicode recordsReggie Burnett11 Nov
Re: Problem when inserting unicode recordsDuncan Paul Attard12 Nov
  • Re: Problem when inserting unicode recordsDuncan Paul Attard13 Nov