Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Encoding of Arabic text

623758Sep 29 2008 — edited Sep 29 2008
Hi All,

i have a oracle database 9.2, it contains a table with arabic text of datatype char. as im new to oracle im not able to view the data in arabic format, im getting the output in symbols. so how to i view the data in arabic format from my table.

Thanks
Fairozkhan

Comments

Gurjas
What is the characterset of the database?
You can view it with sql developer.

Regards
Singh
623758
i dont know how to check the character set in oracle as im new to it, any way it way the default one. please tel me how to check it. and there is only one table with arabic text rest all other tables data is in english format.

Thanks
623758
hi singh
this is the character set for my DB WE8MSWIN1252
Dom Brooks
I'm not sure that WE8MSWIN1252 contains any arabic characters seeing as the WE stands for Western European and the MSWIN1252 presumably for the Windows 1252 codepage.

In which case, what you are storing is not genuine arabic characters. Therefore it's likely that you can only view this through the application as it only makes sense to the application. Outside of the application, it's effectively gobbledygook.

I have come across such a situation previously where an application did something similarly crazy and to translate the garbage that it inserted into the database (via a reverse process of the following) the application a) took the UTF8 stored converted it to Unicode, applied Windows codepage 1252 to the byte stream of that and then to the the result of that applied codepage 1251. This was the cyrillic alphabet ... for the application at least. To everyone else, garbage


If you had genuine arabic character representation - which it sounds like you don't - then you'd need a client that supported that characterset and then have the relevant local settings applied.
Dom Brooks
See related post here:
356561
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 27 2008
Added on Sep 29 2008
5 comments
1,305 views