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. Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/ 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 Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/#findComment-569762 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? Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/#findComment-569844 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. Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/#findComment-570073 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? Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/#findComment-571267 Share on other sites More sharing options...
fenway Posted June 22, 2008 Share Posted June 22, 2008 It's my.cnf, not my.conf. Link to comment https://forums.phpfreaks.com/topic/110914-setting-mysql-system-variables/#findComment-571668 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.