• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
  • Piet Souris
  • Frits Walraven
  • Carey Brown

How to insert arabic letters in MySql through jsp

Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have the Little improvement for the previous requirement.
I have two jsp pages.
first page see.jsp

Employee Name:كيف الحال
Employee id:402

Second page seedb.jsp

Second jsp page shows the result is

id isكيف الحالname is402Successfully database connect Successfully arabic table values are inserted id is:402 name is:كيف الحا

But the Mysql have the content format is numerical.
Name ID

كيف الحا 402

I need the requirement for storing data also have the arabic format in mysql.

Please reply me.

Thanks and Regards


Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have to use Unicode here to insert Arabic data into the database as mysql supports binary.
while viewing of data you have to read it in binary and have to keep encoding as utf-8

May it will help you
zita lakshmi
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Thanks for your reply.

I have the requirement for storing and retrieving of data also in arabic format. But retrieve the data in arabic format is possible for the previous code.I need storing of data also arabic format. It's possible or not.

I given the input is كيف الحال

In the Mysql store in following number format In previous message i have include in number format of data, but it automatically convert in the correct arabic format in your webpage so try to convey this time.

كيف الحا

But it shows in the output in Internet Explorer كيف الحال correct format.

In database I have set Table [ Collation - utf8_general_ci ] and [ Storage Engine - MyISAM ]

So it is Database Issue or Browser Issue.

please guide me.

Please enjoy this holographic presentation of our apocalyptic dilemma right after this tiny ad:
Thread Boost feature
    Bookmark Topic Watch Topic
  • New Topic