[client]
default-character-set=utf8

[mysqld]
language        = /usr/share/mysql/spanish
set-variable    = collation_server=utf8_spanish_ci
init_connect    = 'SET collation_connection = utf8_spanish_ci'
init_connect    = 'SET NAMES utf8'
default-character-set  = utf8
character-set-server    = utf8
collation-server = utf8_spanish_ci

[mysql]
default-character-set=utf8

Luego hay que reiniciar el servidor de MySql

/etc/init.d/mysql restart

Última modificación: jueves, 15 de septiembre de 2011, 01:12