InnoDB case sensitive collation

[Matt Mastrangelo]

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?

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;


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]