German character

Johannes · Post by **Johannes** » 17 Feb 2010, 19:36

Hello
I have some problems with german characters...
When I make mysql query in my serverside extension, for example:

var sql = "INSERT INTO `mydb`.`mytable` (`mess`, `author`) VALUES ('weltberÃ¼hmte', 'me',)";
var queryRes = dbase.executeCommand(sql);

I got question-mark in mysql table instead of umlaut character (Ã¼).
Mysql encoding is utf8 and when I make such query through php it's allright...

How can I resolve this problem?

P.S. sorry for not properly mounting of my post, but within "Code" tags umlaut was not reflected too:

Code: Select all

weltberÃ¼hmte

Post by **Lapo** » 17 Feb 2010, 20:59

This shouldn't happen. Do you have the same problem in the chat, for example?
It could be a driver problem (is the latest?) but if the issue exists in the chat too then it should be something else, maybe the jre not configured correctly or not up to date.

Johannes · Post by **Johannes** » 18 Feb 2010, 08:39

Hello Lapo.
In the chat it's ok, and in flash-client it's ok. Problem appears only when I try to write it into the mysql database

MySQL version: 5.0.67
SFS Pro 1.6.6
java version "1.6.0" (Java(TM) SE Runtime Environment)

Post by **Lapo** » 18 Feb 2010, 15:47

Then I would say the the problem is MySQL related. I would suggest to better investigate the MySQL settings/config or trying a connector update if possible.

Jipii · Post by **Jipii** » 02 Mar 2010, 06:17

Which collation do you set?