Spring Projects > Roo > Issue with Chinese characters

∟Reference Citations in 2012

∟Spring Projects > Roo > Issue with Chinese characters

'Inputting Chinese Text to MySQL Database in UTF-8' tutorial was cited in a Spring Community Forum post in 2012

The Inputting Chinese Text to MySQL Database in UTF-8 tutorial was cited in a Spring Community Forum post in 2012.

Subject: Spring Projects > Roo > Issue with Chinese characters
Date: Jun 4, 2012
Author: Philroc
http://forum.springsource.org/archive/index.php/t-127117.html

I am currently developing a Spring Roo application which will let
users input data in Simplified Chinese and Traditional Chinese. I am
using Mysql as database.

I have found an article on the Web (https://www.herongyang.com
/PHP-Chinese/Input-Chinese-Text-to-MySQL-UTF-8.html) which explains
how to develop a php application to let users input and retrieve
Chinese text into/from a MySQL database. Among other things, the
article suggest setting the following database sessions variables to
utf8: character_set_client, character_set_connection,
character_set_database, character_set_results, and
character_set_system. Although I have set those variables as
suggested, the Simplified Chinese data I input in my Roo application
are displayed as garbage when retrieved from the database.

After rereading the article, I have decided to set the above variables
every time the Roo application connects to the database, as shown
below (in php):

mysql_query("SET character_set_client=utf8", $con);
mysql_query("SET character_set_connection=utf8", $con);

Unfortunately, I have no idea how to issue those commands in
Roo/Hibernate.

Any suggestions?

Many thanks.

Philroc

Issue solved.

I added

useUnicode=true&characterEncoding=utf-8

to the end of the database.url string in database.properties