Bug #619 Something wrong in latin1

• Submitted: 7 Jun 2003 10:28
• Modified: 8 Jun 2003 17:31
• Reporter: Victor Herraiz
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 4.0.12
• OS: Linux (linux and win32)
• CPU Architecture: Any

[7 Jun 2003 10:28] Victor Herraiz

Description:
I think this is a error:
select "a" = "ä";
result 0
or
select "z" > "ä" ;
result 0.

Sorry about me english :D

How to repeat:
mysql> select "a" = "á";
+-----------+
| "a" = "á" |
+-----------+
|         1 |
+-----------+
1 row in set (0.00 sec)

mysql> select "a" = "ä";
+-----------+
| "a" = "ä" |
+-----------+
|         0 |
+-----------+
1 row in set (0.00 sec)

mysql> select "z" > "ä";
+-----------+
| "z" > "ä" |
+-----------+
|         0 |
+-----------+
1 row in set (0.00 sec)

mysql> select "z" < "ä";
+-----------+
| "z" < "ä" |
+-----------+
|         1 |
+-----------+
1 row in set (0.00 sec)

[8 Jun 2003 17:31] MySQL Verification Team

From the MySQL Manual:

"By default, MySQL uses the ISO-8859-1 (Latin1) character set with sorting
according to Swedish/Finnish. This is the character set suitable in the
USA and western Europe."

Then the results you got is according with the Swedish/Finnish sorting
behavior. Please read the below item for further information how you
can manipulate the character set regarding your necessities.

http://www.mysql.com/doc/en/Character_sets.html