Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

seco
15112
accept rate: 0%

edited 01 Apr '12, 14:04

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124

What collation did you use when you created your database?

Take a look at this list of supported collations - http://dcx.sybase.com/index.html#1201/en/dbadmin/recommended-understanding-natlang.html - 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 - http://dcx.sybase.com/index.html#1201/en/dbusage/designing-rebuild-extract.html

(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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×15

question asked: 01 Apr '12, 08:39

question was seen: 2,225 times

last updated: 02 Apr '12, 05:00