text encoding issue ?

Classic Servoy
1

Hi, I’ve a problem with text encoding.
The source of the data is mysql
the text is in french, it should read :

Bienvenue M-` l’Apple ex
Prix spM-hciaux

I’m on a Mac 10.3.1 JVM 1.4.1

2

Are you using the correct characterset in your backend database?

3

Well, I don’t know what the correct charset should be.
In fact, I can’t change the charset of the backend database, so servoy as to get it right.

where can i cahnge the charset of servoy ?

4

After some research I found out it’s a Mac only issue. By default Mac uses different reader and writer Java classes which cause issues with special character sets. You can solve it by launching the JVM with a special option. I’m going to discuss with our development team if and how soon we can implement this. Until then you can launch Servoy using the following method:

  1. open a terminal
  2. change directory to the main Servoy directory
  3. Launch Servoy with the following command:
java -Dfile.encoding=8859_1 -jar servoy_developer.jar
5

GREAT, what a support, thanks.

It works, except for the euro sign. Another setting for the euro sign ?

6

jaleman:

  1. open a terminal
  2. change directory to the main Servoy directory
  3. Launch Servoy with the following command:
java -Dfile.encoding=8859_1 -jar servoy_developer.jar

Wouldn’t it be better to use Unicode? If so, how would the command be?

7

Java works by default in unicode, and so does Servoy. Internally everything in Servoy is in Unicode, when you go out of Servoy it depends on your database, your operating system and environment settings how the data gets out. In this case the database is in 8859_1 encoding. You can also tell your database to store everything in Unicode but that will consume more diskspace.