2 replies to this topic

[arnes99]

In Java by default I have UTF-8 encoding. In MySQL I have UTF-8 encoding as well.
The problem is somewhere in between them. When I store some value that needs utf8 encoding in the database it shows question marks for letters that belong to utf8 (non ascii letters).
NOTE. MySQL table is UTF-8 because I tested it with console input and utf-8 works. Only by storing from Java into MySQL does the problem arises.

Edited by arnes99, 07 June 2011 - 10:15 AM.

[WingedPanther]

The trick is to prefix the string literal with the encoding in your SQL statement. MySQL :: MySQL 5.0 Reference Manual :: 8.1.1 Strings

[arnes99]

WingedPanther said:

The trick is to prefix the string literal with the encoding in your SQL statement. MySQL :: MySQL 5.0 Reference Manual :: 8.1.1 Strings

Tried it and it didn't work. So I set all character set variables to utf8. Again it didn't work. Finally, I added this to database URL: ?characterEncoding=utf8 and it worked! So if anyone is having same problem try it. It worked for me. :pinguin: