Re: Transfer data from UTF-8 encoded MySQL database to ISO-8859-7
Posted by: Takis Bouyouris
Date: March 09, 2006 08:22AM

Hi Kosta!

Yes I am Greek, which proved to be not a very good option when it comes to manipulating greek characters in MySQL.

However I did manage to put UTF-8 characters in MySQL tables, if that's what you are asking! To be honest UTF-8 has been the easiest encoding I have used with MySQL and greek! I program in Java and I suppose you do too...

So, all you need to do is create your database and database tables with utf8 and utf8_general_ci as you did! Then put useUnicode=true&characterEncoding=utf8 in the connection string.

The only thing left is to insert data to the database and retrieve them correctly. Do you want to output the data in an HTMl page (through a JSP perhaps)? Or in a JTable in Swing? I am asking you that because there might be differences...

Tell me exactly what you want and I believe I can send you an example that works!


Options: ReplyQuote

Written By
Re: Transfer data from UTF-8 encoded MySQL database to ISO-8859-7
March 09, 2006 08:22AM

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.