The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

I have a db file contains Arabic text, but the Arabic text did not show correctly. How can I change the encoding to make Arabic text appear correctly?

asked 01 Apr '12, 08:39

seco's gravatar image

accept rate: 0%

edited 01 Apr '12, 14:04

Graeme%20Perrow's gravatar image

Graeme Perrow

What collation did you use when you created your database?

Take a look at this list of supported collations - - it looks like you could use 1256ARA to store your Arabic text.

Note that there is no method of changing the collation used in an already existing database. You will need to unload and reload your data into a new database that has been created using an appropriate collation. See the section in the docs on how to rebuild a database -

(01 Apr '12, 11:42) Mark Culp

What application are you using to view the Arabic text? What, exactly, is "incorrect" about the display? How was the data inserted?

(01 Apr '12, 14:50) John Smirnios

thanks for response i will try and tell you

(02 Apr '12, 02:18) seco
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 01 Apr '12, 08:39

question was seen: 988 times

last updated: 02 Apr '12, 05:00