Jump to content

Faq/Base/010

From The Document Foundation Wiki
< Faq | Base

When I use the JDBC MySQL connector my strings are not correctly encoded

You need to set the Unicode option when you set the connection string for jdbc:mysql.

mysql://host:3306/DatabaseName?useUnicode=TRUE&characterEncoding=<your encoding>

When the character encoding isn't specified then the server encoding will be used. Please consult the MySQL documentation for more information on this subject.