Arabic text not shown correctly

[Former Member]

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?

[MarkCulp]

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

[johnsmirnios]

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

[Former Member]

thanks for response i will try and tell you