Try SELECT DISTINCT BINARY(col) ... Or declare the column as binary -----Original Message----- From: Ricardo To: [EMAIL PROTECTED] Sent: 4/28/04 9:02 AM Subject: SELECT DISTINCT returns an incorrect result with special characters
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
