CODEWITHSUNDEEP
javaoracle-database
Souvik
Souvik

Reputation: 1269

Arabic and English combination recrod retrieval from oracle java

In my master database I have Arabic or Arabic English combination data. Now while reading the Arbic data only it's working fine but for Arabic English combination I am getting different behaviors.

In java it should be display Value stored in the database.

CHARACTER SET in Database - AR8ISO8859P6.

Value stored in the database or can be fetched from PL/SQL Developer- Value stored in the database

Value I am getting from java or Toad developer -enter image description here

Upvotes: 0

Views: 225

Answers (1)

Joni
Joni

Reputation: 111259

Both values you see are correct. They just have a different "base direction" which is set by the software that displays the text.

If the base direction is left to right, "english arabic" is rendered as "english cibara". If the base direction is right to left, "english arabic" is rendered as "cibara english". Both renderings are valid, and which one should be used depends on the context.

You can read more about the bidirectional text layout algorithm at https://www.w3.org/International/articles/inline-bidi-markup/uba-basics

Upvotes: 0

Related Questions