MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: incorrect results with WHERE clause on table with accented characters
2558
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.