I'm having a problem when inserting the following records...
insert into kbase values ('arċhaiċ', '', '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'.
Note:
This is the show create output:
# Host: localhost
# Database: corpus
# Table: 'kbase'
#
CREATE TABLE `kbase` (
`word` varchar(100) NOT NULL default '',
`changes` varchar(100) NOT NULL default '',
`status` enum('unknown','accept','reject','change') NOT NULL default
'unknown',
PRIMARY KEY (`word`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
If I insert 'aċċessibbli' and afterwards I insert 'accessibbli' the second insertion is not successful (duplicate key).
If I insert 'adeżjoni' and afterwards I insert 'adezjoni' the latter insertion is unsuccessful (duplicate key).
If I insert 'beħsiebna' and, afterwards I insert 'behsiebna' the insertion IS successful.
If I insert 'appoġġ' afterwards I insert 'appogg' the latter insertion is unsuccessful.
If I insert 'realtą' and then insert 'realta' the second insertion is unsuccessful.
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
dBforums
>
Problem when inserting unicode records
11-12-04, 06:38
Linear Mode
