wood burning stoves 2.0*
The moose likes Java in General and the fly likes Arabic in MySQL ... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Arabic in MySQL ..." Watch "Arabic in MySQL ..." New topic
Author

Arabic in MySQL ...

Vassili Vladimir
Ranch Hand

Joined: Mar 08, 2007
Posts: 1585
Hi,

I don't know if this is the right place to post this question, but, how can i insert arabic text in a MySQL DataBase ?

Thanks ...


Vassili ...
SCJP 5.0, SCWCD 1.4, SCJA 1.0
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Use an SQL INSERT statement.

But first, make sure your MySQL database and tables are configured to accept those characters. It's not unusual for Latin-1 to be the charset used by MySQL.
Vassili Vladimir
Ranch Hand

Joined: Mar 08, 2007
Posts: 1585
Please can you guide me on how to do that ?

Which charset to use ?

Thanks ...
Nikos Pougounias
Ranch Hand

Joined: Jan 16, 2008
Posts: 110
Which charset to use ?

UTF-8

Please can you guide me on how to do that ?

MySQL has a detailed step-by-step wizard. When it's about charset you should choose "Best Support For Multilingualism".


Nikos' Java blog
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Arabic in MySQL ...
 
Similar Threads
mySQL is it support arabic language and how?
I got ??? in stead of Arabic characters after conversion to utf8 in mysql using mysqlWorkBench
insert query for mysql convert() using the tomcat
applet send arabic to servlet
how can i insert the arabic data in Mysql