Mysql SET NAMES UTF8 - how to get rid of?
- by Nir
In a very busy PHP script we have a call at the beginning to "Set names utf8" which is setting the character set in which mysql should interpret and send the data back from the server to the client.
http://dev.mysql.com/doc/refman/5.0/en/charset-applications.html
I want to get rid of it so I set default-character-set=utf8 In our server ini file. (see link above)
The setting seems to be working since the relevant server parameters are :
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
But after this change and commenting out set names utf8 call still the data starts to come out garbled.
Please advise....
