MySQL Bugs: #13055: Problem with special chars and iso-8859-1

Bug #13055	Problem with special chars and iso-8859-1
Submitted:	8 Sep 2005 8:39	Modified:	8 Sep 2005 10:48
Reporter:	Arne Stegemann	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.25	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
Assume you have a standard installation of MySQL 4.0.25 (using charset iso-8859-1) and a table with 2 field 'ID' (int(11) unsigned NOT NULL auto_increment) and 'name' (varchar(64) NOT NULL default '').

Assume that you'll insert data into the table with name = 'Earina'. Also assume that it has the ID 69 for example. Afterwards you check if the name 'Eariná' is already inside the db:
SELECT id from `table` WHERE name = 'Eariná';

MySQL returns the ID 69! That is the ID for the name 'Earina'.

How can this be fixed?

How to repeat:
Just create a table with the above given fields and insert the name 'Earina'. Afterwards execute the above given SELECT-statement. You'll find that:
Earina is ID 69 and Eariná is ID 69.

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Please read what the manual says on collations and choose an appropriate collation. For instance, the accented and non-accented characters will be treated as inequal in the binary collation.