Archive | February, 2014

Grails save other characther

19 Feb

In mysql:

SET character_set_results = ‘utf8’, character_set_client = ‘utf8’, character_set_connection = ‘utf8’, character_set_database = ‘utf8’, character_set_server = ‘utf8’

ALTER TABLE t MODIFY col1 CHAR(50) CHARACTER SET utf8;

In url connection:

from: “jdbc:mysql://localhost:3306/table?autoReconnect=true”

changed to: “jdbc:mysql://localhost:3306/table?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8”