>Description: <MYSQL returns "ERROR 1062: Duplicate entry 'xxxxxx' for key x" when creating a UNIQUE KEY on CHAR fields that contain more occurencies of the same value written with different cases. See example below. > >How-To-Repeat: <Please run these few SQL statements CREATE TABLE dummy (a CHAR(1)); INSERT INTO dummy VALUES('b'); INSERT INTO dummy VALUES('B'); CREATE UNIQUE INDEX dummy_idx ON dummy(a);
Now you should get the error.... > >Fix: <I read carefully the manual and I tried to change the column type to CHAR(x) BYNARY It seems to me that it is not possible to force MYSQL to treat the fields literrally when creating indexes (though it is possible in the SELECT statements) I haven't find any server variable that concerns this feature. More likely than not I am a dumb, and the solution is right under my noose, but at the moment I am stucked > THANX >Submitter-Id: <[EMAIL PROTECTED]> >Originator: root >Organization: <Emmegi S.p.A. (www.emmegi.it)> >MySQL support: [none ] >Synopsis: <Unique indexes and case sensitivity bug(?)> >Severity: <serious> >Priority: <medium> >Category: mysql >Class: <sw-bug> >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 47 min 47 sec Threads: 6 Questions: 2429 Slow queries: 1 Opens: 69 Flush tables: 2 Open tables: 24 Queries per second avg: 0.847 >Environment: <machine, os, target, libraries (multiple lines)> System: Linux mandrake 2.4.3-20mdksmp #1 SMP Sun Apr 15 22:32:27 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 20000731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' -O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 ago 27 00:40 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x 1 root root 1216268 feb 21 2001 /lib/libc-2.2.2.so -rw-r--r-- 1 root root 26366908 feb 21 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 feb 21 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien t-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/us r/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embe dded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php