SolveErrors
MYSQL

Italian Characters are stored as "?" in the database.

9 views

I have a strange problem.

My application supports Internationalization for Italian, French and German languages. The database is - MySQL 5.0.45 and the 'my.cnf' file has the following entries about the character set:

Under - [mysqld] - Section
init_connect='SET NAMES utf8'

and under - [mysql] ? Section
default-character-set=utf8

In the JSPs, the tag's content is set to "text/html charset=UTF-8".
All the tables are created in the InnoDB engine with defaul charset = UTF-8 and ENGINE = Innodb

Application server: Sun ONE App server 9.1
Operating System: Redhat Linux Server version 4 Update 6.

Italian characters (? & ?) are stored as ? in the database. They are properly rendered on the browser and in the application log on the app server they are displayed as - ? & ? respectively.

Note: When I deploy the application on Windows XP box, the characters are stored & displayed properly. Whereas, it behaves strangely on RHL box.

Please help me.

Thank you in advance.

More MYSQL fixes

Mysql DumpingMySQL resourcesNeed help understanding error messageHow to pull a list....Select finding no dataconvert the query mssql database to mysql database