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

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

Any suggestions?

Many thanks.


Issue solved.

I added


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

Table of Contents

 About This Book

 Reference Citations in 2023

 Reference Citations in 2022

 Reference Citations in 2021

 Reference Citations in 2020

 Reference Citations in 2019

 Reference Citations in 2018

 Reference Citations in 2017

 Reference Citations in 2016

 Reference Citations in 2015

 Reference Citations in 2014

 Reference Citations in 2013

Reference Citations in 2012

 bikin website dalam bahasa cina dengan php

 72 sekunde kao 72 godine

 nsIConverterOutputStream handling GB2312 characters

 AbstractMethodError while calling PreparedStatement.setBinaryStream()

 how to invoke web service without generating a client

 Sample program to test SSL Connection with certicates

 How to know KeyManager given a keystore

 once again: classpath and ojdbc14.jar

 12c... webtier up, Oracle managment server down

 Problems with class not found exception

Spring Projects > Roo > Issue with Chinese characters

 Monkey Programming/Unsigned Shift Right

 Unable to get issuer certificate

 How to convert keystore (from native android project) to .p12 to use with AIR project?

 Installing JDBC drivers ojdbc14.jar

 Quickly view the threads of your blocked Ruby application with JStack

 android verify signature of file with .der public key

 Unable to install updates KB2770917 and KB2779768

 Reference Citations in 2011

 Reference Citations in 2010

 Reference Citations in 2009

 Reference Citations in 2008

 Reference Citations in 2007

 Reference Citations in 2006

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003