Re: InnoDB case sensitive collation
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]
Re: InnoDB case sensitive collation
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
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]
InnoDB case sensitive collation
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]
