Frequently asked questions - Base

    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.