Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Encoding of Arabic text

623758
Member Posts: 109
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
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
Tagged:
Answers
-
What is the characterset of the database?
You can view it with sql developer.
Regards
Singh -
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 -
hi singh
this is the character set for my DB WE8MSWIN1252 -
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. -
See related post here:
356561
This discussion has been closed.