Skip navigation
2009

Nicolai Abruzzese's Blog

August 2009 Previous month Next month

Articulo Desactualizado

Esta configuracion es necesaria en modo local para evitar que los acentos y otros caracteres no se desplieguen de forma equivocada.

Configurar char set de MySQL

Configurar char set de MySQL  /etc/mysql/my.cnf
[client]
default-character-set = utf8

[mysqld]
skip-character-set-client-handshake
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8

[mysqldump]
default-character-set = utf8

[mysql]
default-character-set = utf8

Verificar:

mysql> shwo variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

#Then set charset
mysql>set character_set_database=utf8
mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Para evitar permgen y que el IDE ralentezca, cambiar el archivo:  HOME/netbeans6.7/etc/netbeans.conf  la linea siguiente:
netbeans_default_options=" -J-Dcom.sun.aas.installRoot=\"/home/nicolai/Apps/SUNWappserver\" -J-client -J-Xss2m -J-Xms64m -J-Xmx786m -J-XX:PermSize=64m -J-XX:MaxPermSize=300m -J-Xverify:none -J-Dapple.laf.useScreenMenuBar=true -J-Dsun.java2d.noddraw=true -J-XX:+UseConcMarkSweepGC -J-XX:+CMSClassUnloadingEnabled -J-XX:+CMSPermGenSweepingEnabled --fontsize 9"