Most bizzare problem with Unicode (UTF8)
Posted by: George Bougiakas
Date: April 13, 2005 09:38AM

I have a java client and I am using the latest version of stable mySQL and jdbc driver. During the mySQL installation I checked the set UTF8 as default encoding for my databases.

I create a UTF8 database using Navicat and I import data from an Access Database.

- In Navicat imported unicode characters display just fine.
- In java client imported unicode characters display like this:
ÐÑÏÌ.ÊÁÔ.ÓÕÍ.ÉÍÊÁ ×ÁÍÉÙÍ ÐÅ ÅÐÉÓÊÏÐÇ ÁÃÉÁÓ
- If I use my java client to store something to the DB in Navicat is shows up like this:
?????? ??? ???
BUT - in java client it shows up just fine.

So basically if I empty my database and start using my java client to manipulate data (as I do most of the times) everything works just fine.

If I import data from MS Access i get the mess.

Is there any chance someone knows whats going on?
Is there a better tool that converts MS Access to mySQL that handles Unicode properly?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Most bizzare problem with Unicode (UTF8)
4553
April 13, 2005 09:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.