aspose file tools
The moose likes JDBC and the fly likes I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench " Watch "I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench " New topic
Author

I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench

alsoumahi alBatal
Ranch Hand

Joined: Nov 22, 2009
Posts: 84
Hi experts , I have converted my database to utf8 and collate is utf8_general_ci and also the table (it is utf8 , collate utf8_general_c)including all the fields(utf8 , collate utf8_general_c)
that contain Arabic characters , but when I display the values using mysqlWorkBench , it display ??? with the same number characters of Arabic word , how to show Arabic word
I think there is something missing

thanks in advance
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 32712
    
    4
What are you displaying the output on? Some DOS command line windows cannot support non-European characters.
alsoumahi alBatal
Ranch Hand

Joined: Nov 22, 2009
Posts: 84
Campbell Ritchie wrote:What are you displaying the output on? Some DOS command line windows cannot support non-European characters.


it displays ??? not the Arabic characters , also I have tried to view the the values of table from mysql command prompt , but still I can't view the Arabic characters from the the mysql command prompt , why is that ???, how to make mysql prompt or mysqlQorkBench support arabic language how is done that !!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench
 
Similar Threads
simple problem Convert latin1 to UTF-8 in MySQL
Can't write arabic text into mysql database using mysql prompt
how to convert mysql tables to utf-8 ?
simple problem Convert latin1 to UTF-8 in MySQL
simple problem Convert latin1 to UTF-8 in MySQL