SELECT DISTINCT returns an incorrect result with special characters

[Ricardo]

I have a problem with SELECT DISTINCT if the target
field contains special characters.

Example:

select MyField from MyTable     
+----------+
| MyField  |
+----------+
| fá       |
| Fá       |
| fa       |
| Fa       |
| fâ       |
| Fâ       |
| fã       |
| Fã       |
+----------+

select distinct MyField from MyTable
+----------+
| MyField  |
+----------+
| fá       |
+----------+

MyField is varchar type and MyTable is InnoDB.

Is there any way to change this behaviour in MySQL? I
use version 4.0.16.

Thanks.

______________________________________________________________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora! 
http://br.download.yahoo.com/messenger/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]