Frequently asked questions - Base

From The Document Foundation Wiki
< Faq‎ | Base
Jump to: navigation, search

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.