unique key bug

Hello,

first of all a happy new year to all!

version: 4.1 latest bk

How-to-repeat:

tested with latin1, latin_1.de

mysql> create table a (term varchar(50) unique, germantranslation
varchar(100));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values ("Exposé", "Exposee"), ("expose", "entdecken");
ERROR 1062: Duplicate entry 'expose' for key 1

Exposé = expose ?!

or do I need a special charset?

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13389@lists.mysql.com
To unsubscribe, e-mail

Re: unique key bug

At 19:02 +0100 1/1/03, Georg Richter wrote:
>Hello,
>
>first of all a happy new year to all!
>
>version: 4.1 latest bk
>
>How-to-repeat:
>
>tested with latin1, latin_1.de
>
>mysql> create table a (term varchar(50) unique, germantranslation
>varchar(100));
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> insert into a values ("Expos=E9", "Exposee"), ("expose", "entdecken"=
);
>ERROR 1062: Duplicate entry 'expose' for key 1
>
>Expos=E9 =3D expose ?!

They're identical in the collating order, therefore in comparisons.

>
>or do I need a special charset?

Try one of the ones that ends in "csas" (case-sensitive, accent-sensitive).
You can find out the names with SHOW CHARACTER SET. (Assuming you've
compiled with --with-extra-charsets=3Dall)

>
>Regards
>
>Georg


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13390@lists.mysql.com
To unsubscribe, e-mail