random1 Posted February 3, 2012 Share Posted February 3, 2012 Part of my my.ini file is: [client] port=3306 collation_connection=utf8_unicode_ci default-character-set=utf8 [mysql] collation_connection=utf8_unicode_ci collation_database=utf8_unicode_ci default-character-set=utf8 [mysqld] port=3306 basedir="C:/webserver/mysql/" datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/" user=mysql collation_server=utf8_unicode_ci character-set-server=utf8 init_connect='SET collation_connection = utf8_unicode_ci; SET NAMES utf8;' skip-character-set-client-handshake However when I check the server when running collation_connection = utf8_general_ci. Any ideas what I'm missing here? How can I set this value globally? BTW I'm running MySQL Server 5.5. Reference: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_collation_connection Quote Link to comment Share on other sites More sharing options...
fenway Posted February 4, 2012 Share Posted February 4, 2012 Are you sure the server is actually reading that startup file? 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.