order by clause with latin5 character set on binary fields

[Veysel Harun Sahin]

Hello,

I use mySQL 3.23.49 with latin5 character set. At some of my tables I use binary fields. At normal fields order by clause returns true sorting but at binary fields I get wrong results. Is there any way to correct this problem or have to I use normal fields instead of binary and use "BINARY" operator at comparisions?

Thanks.


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php