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" <victoria.reznichenko@stripped>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, May 18, 2004 4:00 PM
Subject: Re: InnoDB case sensitive collation
> Matt Mastrangelo <mmastrangelo@stripped> 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
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
> /_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=1
>
