Weird Characters in OpenOffice Base with MySQL

I’m using Apache OpenOffice Base 4 with MySQL 5.6.  I noticed some question marks appeared where I should have seen some non-English characters (inuit characters).  I had set up the database properly to use UTF-8.  But, it turned out I used the ANSI ODBC driver.  Switching to the Unicode Driver easily fixed the problem.

Leave a Reply

Your email address will not be published. Required fields are marked *