Re: French characters ok with mysql in Windows, nok with mysql in Linux
From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18nsa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, I changed etc/sysconfig/i18n to: LANG=fr_FR SUPPORTED=fr_FR:fr SYSFONT=lat0-sun16 SYSFONTACM=iso15 and everything works perfectly. Thank you very much for your help. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: dinsdag 6 januari 2004 8:39 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18n; sa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i 18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French characters ok with mysql in Windows, nok with mysql in Linux
From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, Thank you for your quick response. I start with an empty database. So the data isn't exported. Then users enter data in a web-page. It is this data that can contain French characters and that is added by the java servlet to the database. I will look at the file /etc/sysconfig/i18n this evening (I can not get on the Linux system at this moment). I'm not a linux-expert. I didn't change anything in that file until now. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Both are the same: Character-set : latin1 Character-sets : a long list Convert_Character_set : Is that like it should be? Greetings, Willy Dockx -Original Message- From: Oriol [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:55 To: Willy Dockx Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux Have you looked at character set options in MySQL config files? You can see the differences between the servers executing the query: show variables like '%character_set%'; Bye Oriol - Original Message - From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Greetings, Willy Dockx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]