Ricardo wrote:
Which collation are you using in MS SQL Server? And in MySQL?
MS SQL Server 8 Collation = Latin1_General_CI_AS
MySQL 4.0.16 character_set = latin1
The charset determines which characters can occur. The collation determines the sort order. What is the collation in MySQL?
http://dev.mysql.com/doc/mysql/en/Charset-server.html
That's for 4.1 and up. There isn't such a concept of collation in 4.0.x.
Ricardo, you might try SELECT DISTINCT BINARY col_name rather than SELECT DISTINCT col_name.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]