I'm inserting data from a JAVA desktop application(JDBC) to a mysql database. Data has some arabic words. When browsing table data using phpmyadmin interface I just have interrogation marks "????????????". What can I do to solve that problem? Thank you very much.
Asked
Active
Viewed 1,349 times
0
-
3Related: [UTF-8 all the way through](http://stackoverflow.com/q/279170) – Pekka Feb 25 '13 at 19:21
-
1Is the problem in the database or in phpmyadmin? – user207421 Feb 25 '13 at 22:21
-
@EJB: The problem was coming from the Mysql my.ini file. Will post my answer. – androniennn Feb 25 '13 at 22:31
2 Answers
0
Just add this 2 lines in my.ini file \wamp\bin\mysql\mysql5.5.24\my.ini in [mysqld] category:
[mysqld]
//you will find surely some data/lines in [mysqld] category, just add the following lines
character-set-server=utf8
collation-server=utf8_general_ci
androniennn
- 3,117
- 11
- 50
- 107
0
You can go to your PhpMyAdmin then change the collation of your database to cp1256_general_ci then go to table options and also set the collation as cp1256_general_ci and so the collation for the field that may contain Arabic words to the same..
Hussam Mouazzen
- 71
- 2
- 8