OraFAQ Forum: SQL & PL/SQL » Converting data from English to Arabic (merged 3)

Home » SQL & PL/SQL » SQL & PL/SQL » Converting data from English to Arabic (merged 3) (Oracle 10g Database on Red Hat Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Converting data from English to Arabic (merged 3) [message #541568]

Wed, 01 February 2012 03:47

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

Dear All

I need to prepare a bilingual system (English and Arabic).

So i need to store data in English as well as in Arabic

so can anyone tell me, Is there any possibility to convert the data from English to Arabic and Arabic to English through oracle forms

basically what i am thinking is let us suppose user selected the English version of the application and he entered all the data in English during saving the records i need to convert all the English data into Arabic and store it in another table for Arabic data reference.

thanks and regards

sarfarazh attari

Report message to a moderator

Re: Converting data from English to Arabic (merged 3) [message #541575 is a reply to message #541568]

Wed, 01 February 2012 04:16

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

so can anyone tell me, Is there any possibility to convert the data from English to Arabic and Arabic to English through oracle forms

There is nothing to convert at SQL level, use a character set for your client and database that understands both languages.
Any arabic character set includes all english character, so use one of them.

Quote:

he entered all the data in English during saving the records i need to convert all the English data into Arabic and store it in another table for Arabic data reference.

If you mean "translate" then you must have a translator somewhere.
You can use "google translate" on the fly.
This question was asked and answered here, please search for it in this "SQL & PL/SQL" subforum.

Regards
Michel

Report message to a moderator