random1 Posted June 19, 2008 Share Posted June 19, 2008 Hi All, I'm trying to get MySQL all using utf8 only. Screen: How can I set the system variables to stay persistant? I have tried "character_set_server = utf8" in the my.conf file with no affect. I have tried "SET session character_set_server = 'UTF8'" in an SQL query with no affect. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted June 20, 2008 Share Posted June 20, 2008 http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_character-set-server Quote Link to comment Share on other sites More sharing options...
random1 Posted June 20, 2008 Author Share Posted June 20, 2008 Thanks, but how do I set that? Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted June 20, 2008 Share Posted June 20, 2008 my.(cnf|ini), depending on your operating system. Perhaps you should ask your DBA to set it up. Quote Link to comment Share on other sites More sharing options...
random1 Posted June 22, 2008 Author Share Posted June 22, 2008 I tried setting it up in my.conf: Still no affect, not even temporary. I tried it in SQL as well: SET character_set_server = 'utf8' #SHOW VARIABLES This works for the current session but once mysql is restarted it changes back. Any persistant way of doing this? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 22, 2008 Share Posted June 22, 2008 It's my.cnf, not my.conf. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.