RE: MySQL character set problems - Moritz Petersen - com.mysql.lists.java

5 messages in com.mysql.lists.javaRE: MySQL character set problems

From	Sent On	Attachments
Marco Pöhler	06 Aug 2002 06:01
Sebastian Ghiurca	06 Aug 2002 07:52
Moritz Petersen	06 Aug 2002 09:07
Sebastian Ghiurca	06 Aug 2002 11:04
Moritz Petersen	07 Aug 2002 00:38

Subject:	RE: MySQL character set problems
From:	Moritz Petersen (mori...@mac.com)
Date:	08/06/2002 09:07:25 AM
List:	com.mysql.lists.java

Hi Sebastian,

thank you for your reply. Can you please tell me how I use the locales package? I have set the LC_ALL environment variable to de_DE.ISO-8859-1, but it has no effect to the application.

Thank you in advance,

On Tue, Aug 06, 2002 at 03:01:41PM +0200, Marco Pöhler wrote:

The confusing part is, that it worked very well before the re-installation. We didn't change the code.

The umlauts (äöüÄÖÜß) are stored in the database, so the question marks appear in the transition step when accessing the database using JDBC.

Sounds like a locales mismatch, the user you're running the JSP engine as uses a locale that can't read umlauts. Same would happen if you tried to read a piece of text containing special characters in console mode ( your mail for example :-) )

Install the `locales` package, and use `de_DE.ISO-8859-1` (or other locale that can read umlauts).

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.