MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: incorrect results with WHERE clause on table with accented characters
Posted by: Heikki Tuuri
Date: January 19, 2005 08:48AM

Hi!

Before 4.1, one could use in MySQL latin1, latin2, latin1_de, etc., but it was a server-wide setting in my.cnf. InnoDB and MyISAM all used the same.

If you use latin1_de, then umlaut-u will be identified with u. Of course, you understand that if you put different languages into the same column, the sorting order cannot be right for all of them. For example, the Czeck sorting order is different from all the other languages.

Why not use 4.1.9? We are slowly phasing out 4.0.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
incorrect results with WHERE clause on table with accented characters
4020
mb33140
January 12, 2005 01:13PM
Re: incorrect results with WHERE clause on table with accented characters
2717
Heikki Tuuri
January 12, 2005 05:26PM
Re: incorrect results with WHERE clause on table with accented characters
3322
mb33140
January 18, 2005 04:34AM
Re: incorrect results with WHERE clause on table with accented characters
2823
Heikki Tuuri
January 19, 2005 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.