Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
> How can an InnoDB table be created with case sensitive collation? The
> example below creates two identical tables, one MyISAM and the other
> InnoDB. The InnoDB fails when inserting primary keys that differ in case
> only. What am I doing wrong?
Which version do you use?
Worked fine for me on 4.1.2:
mysql> INSERT INTO `table_02` VALUES ('victoria'), ('Victoria');
Query OK, 2 rows affected (0.04 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM `table_02`;
+----------+
| tst_key |
+----------+
| Victoria |
| victoria |
+----------+
2 rows in set (0.00 sec)
>
> Thanks.
>
> drop database test;
> create database test default character set latin1 default collate
> latin1_general_cs;
> CREATE TABLE `table_01` (`tst_key` varchar(10), PRIMARY KEY(`tst_key`))
> Type=MyISAM DEFAULT CHARSET latin1 COLLATE=latin1_general_cs;
> CREATE TABLE `table_02` (`tst_key` varchar(10), PRIMARY KEY(`tst_key`))
> Type=InnoDB DEFAULT CHARSET latin1 COLLATE=latin1_general_cs;
>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
