Hi, I have a problem setting default collation for each connection. I have multilanguage site and I don't want to add COLLATE statement to every SQL - I could set it once during PHP startup and forget about it... But there's a problem.
I tried to do SET names 'utf-8'; SET collation_connection = 'utf8_polish_ci'; and I think it should set collation in this connection to default 'utf8_polish_ci'. Because depending on what user language will choose I can set i.e. 'utf_8_romanian_ci'. So this does not work. When i use SQLs that search smth with LIKE I get no results entering polish national char in different case than it is in DB. Any suggestions? Please help as I don't want to add to every SQL COLLATE statment because it's not even possible - many of theese SQLs are generated automagically... P.S. I use MySQL 4.1.4 on Windows XP Home machine. P.S2 I store data in one table which has no default collation set only UTF-8 charset. In this table I can have data in different collations. -- "Use the force - read the source" Piotr Duszynski mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]