Matt, InnoDB only supports multiple charsets and collations in the same installation starting from 4.1.2. That might be associated with the problem. Please wait that 4.1.2 is released.
Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, May 18, 2004 4:00 PM Subject: Re: InnoDB case sensitive collation > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
