MySQLers: When I started porting an app from MSSQL to MySQL, I got a flurry of error messages complaining of "Illegal mix of collations for operation ' IN '".
I want to set all encodings to utf8 and leave them there. I finally managed (despite "help" from winmysqladmin.exe and the Services Control Panel applet) to start mysqld-nt with --default-character-set=utf8 (from a batch file). But the problem remains. Prefixing every string in the database with _utf8 is not an option, because then some statements still collide with them. How do I put a bullet in this problem? ===== Phlip http://www.xpsd.org/cgi-bin/wiki?TestFirstUserInterfaces __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]