I've solved the problem starting the server using the option --character-set=dos.
The side effect is that searches become accent-sensitive. Best wishes. --- Ricardo <[EMAIL PROTECTED]> escreveu: > 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/ > ______________________________________________________________________ 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]