So...
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;
and these are the character codes in C# format (to get an idea
of how the characters look like, take a look at the character map
of windowsXP).
Small a with a an accent on top of its head: \u00e0 (U+00E0)
Small c with a dot on top of its head: \u010b (U+010B)
Small h with a small line through its head: \u0127 (U+0127)
Small z with a small dot on top of its head: \u017c (U+017C)
-----------------------
Pls note the following:
If I insert 'accessibli' with the small dots on the c's
and afterwards I insert 'accessibli' without the dots
on the c's (i.e. normal english 'c'), the second insertion is
not successful (duplicate key).
If I insert 'adezjoni' with the small dot on the z,
and afterwards I insert 'adezjoni' without the dot
on the z, the latter insertion is unsuccessful
(duplicate key).
If I insert 'behsiebna' with the h having a small line
through its head, and, afterwards I insert 'behsiebna'
with a normal 'h' (i.e. as in the quotes), the insertion
IS successful.
If I insert 'appogg' with the dots on the g's and afterwards
I insert 'appogg' with a normal english 'g', the latter insertion
is unsuccessful.
If I insert 'realta' with the accent on the 'a', and then insert
'realta' without an accent on the 'a', the second insertion
is unsuccessful.
Duncan
