Jump to content

collation_connection issue


random1

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/256311-collation_connection-issue/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.