Non ascii characters in mysql in Linux - Willy Dockx - com.mysql.lists.java

1 message in com.mysql.lists.javaNon ascii characters in mysql in Linux

From	Sent On	Attachments
Willy Dockx	21 Nov 2003 14:05

Subject:	Non ascii characters in mysql in Linux
From:	Willy Dockx (will...@pandora.be)
Date:	11/21/2003 02:05:50 PM
List:	com.mysql.lists.java

Hello,

I have a web-application with J2EE on JBoss and MySql. For development this runs on a win2000 machine and I can enter non-ascii characters like the french éèà... and it is displayed correctly under all circumstances.

The production environment is on RedHat 8.0 and there the characters are not displayed correctly.

Now I tried suggestions I found on the Internet like adding ?useUnicode=true&characterEncoding=UTF-8 to the DB connection URL, but this all didn't help me very much. I think it has to do with Redhat default encoding being UTF-8, but i am rather new to Linux, and mysql not supporting this UTF-8. Can I change this default encoding in Redhat to Iso-8859-1? Or can I leave it UTF-8 and solve it in another way?

Also the mysql console doesn't display the character correctly, so I don't think it has to do with the web pages.

Greetings,