Re: InnoDB case sensitive collation

2004-05-18 Thread Victoria Reznichenko
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

Re: InnoDB case sensitive collation

2004-05-18 Thread 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

Re: InnoDB case sensitive collation

2004-05-18 Thread Heikki Tuuri
, 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

InnoDB case sensitive collation

2004-05-17 Thread 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