Notes on Reference Citations - Version 2.71, by Dr. Herong Yang
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 (http://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
Table of Contents