Re: Transfer data from UTF-8 encoded MySQL database to ISO-8859-7

[Takis Bouyouris]

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!

Cheers...