Re: InnoDB case sensitive collation

[Matt Mastrangelo]

I'm using version 4.1.1-alpha, running on RedHat Linux 9.
Victoria Reznichenko wrote:
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;


   


 

--
Matt Mastrangelo
X2 Development Corporation
781-740-2679