Question Re: Arabic text not shown correctly in Technology Q&A

Arabic text not shown correctly

Former Member — Sun, 01 Apr 2012 08:39:58 GMT

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?

Re: Arabic text not shown correctly

MarkCulp — Sun, 01 Apr 2012 11:42:52 GMT

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

Re: Arabic text not shown correctly

johnsmirnios — Sun, 01 Apr 2012 14:50:07 GMT

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

Re: Arabic text not shown correctly

Former Member — Mon, 02 Apr 2012 02:18:20 GMT

thanks for response i will try and tell you