Greek characters are stored in mysql database like "?????????".Please help.

[mariosarmy]

I did an application with jframe which i store member personal info like name, surname etc.But when i save it to Mysql database the values are ??????.I have changed database and table and columns collation to utf8, i checked java encoding it's utf-8 but the problem remains.Please help i have spent hours in google search but nothing that works.
Thanks in advance.

[GregBrannon]

Try this article. And practice your searching. I found many useful articles and StackOverflow topics that cover this problem from many different angles.

[syedbhai]

Hello.
I would suggest this.
Login to MySql database directly from the command prompt in windows or shell terminal in linux. Try to insert some data. And then read this data. See if you get them right. If yes then there shall be no problem with java i suppose.
Let me hear from you.

Syed.

[mariosarmy]

Thanks for the answer but i am not doing a web app.I am doing an application using java and jframe.

--- Update ---

Hello.
I would suggest this.
Login to MySql database directly from the command prompt in windows or shell terminal in linux. Try to insert some data. And then read this data. See if you get them right. If yes then there shall be no problem with java i suppose.
Let me hear from you.

Syed.

Hello mate, i have inserted data from mysql and i get them right.So I suppose it's java problem because when i try to insert data from jframe app i dont get them right.But i checked as i have mention above that the project->properties->unicode its UTF-8.

[syedbhai]

Hello.
I see. Thanks for the update.
Now can you write java console application. Just use plain JDBC. Insert some data using the program.
And read it at the command/shell prompt.
Let me see if you get the right data.

Syed.

[mariosarmy]

Hello.
I see. Thanks for the update.
Now can you write java console application. Just use plain JDBC. Insert some data using the program.
And read it at the command/shell prompt.
Let me see if you get the right data.

Syed.

As i have understand i must enter data to app and then check from mysql control panel->shell prompt if the data in the database are ok.I did it but the ????? remains.

[syedbhai]

Hello.
I have asked you to write a console app in java. Not the one you have already written earlier.
Did you write one more separate console app just to ensure if the data is stored properly in the db?

Syed.

[mariosarmy]

Hello.
I have asked you to write a console app in java. Not the one you have already written earlier.
Did you write one more separate console app just to ensure if the data is stored properly in the db?

Syed.

Untitled.jpg
I have run the application with greek letters but the problem remains.I made the app in the photo.Sorry i am beginner.

[mariosarmy]

After many hours i found that it's when i assign the variable with greek characters in sql to execute it that cause the problem.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??????,'var2','var3','var4',1234,1234,1234,1234,' 2013-10-05')' at line 1

Anyone which can help

[arvindbis]

Tell me where are you writing these SQL Queries?? I assume you may be using console. right?