From: Duncan Paul Attard
Date: November 11 2004 2:05pm
Subject: Problem when inserting unicode records
List-Archive: http://lists.mysql.com/dotnet/129
Message-Id: <000901c4c7f7$81561b50$a800a8c0@logos>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0006_01C4C7FF.E2CFBEB0"

------=_NextPart_000_0006_01C4C7FF.E2CFBEB0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20
from you.

Duncan Paul Attard.
------=_NextPart_000_0006_01C4C7FF.E2CFBEB0--