Re: Problems with UTF and MySQL

2006-03-28 Thread Gabriel PREDA
Yes you are right it works... but if the documentation is wrong I will be wrong in the following also... Majority of SET statements are documented without quotes: AUTOCOMMIT = {0 | 1} BIG_TABLES = {0 | 1} FOREIGN_KEY_CHECKS = {0 | 1} IDENTITY = value INSERT_ID = value LAST_INSERT_ID = value SQL_AU

Re: Problems with UTF and MySQL

2006-03-28 Thread Adam i Agnieszka GÄ…siorowski FNORD
On 2006-03-20, at 16:12, Gabriel PREDA wrote: One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!

Re: Problems with UTF and MySQL

2006-03-20 Thread Gabriel PREDA
One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!! -- Gabriel PREDA Senior Web Developer