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!

SQL Translate Function to convert Engilsh Number to Arabic Numb

Ramesh9158Nov 28 2013 — edited Nov 28 2013

Hi,

We are using below sql statement to convert English number to Arabic Number...

select translate('12',

                     '0123456789',

                     unistr('\0660') || unistr('\0661') || unistr('\0662') ||

                     unistr('\0663') || unistr('\0664') || unistr('\0665') ||

                     unistr('\0666') || unistr('\0667') || unistr('\0668') ||

                     unistr('\0669')) arabic_numerals from dual;

Problem is that it requires the database character set either UTF8 or AL32UTF8 ..

But our User refuses to change the database character set value.....So we are getting "????" mark as result...

Can any one help us how to achieve that...By using any NLS_PARAMS...

By the Way

if we execute the below query...

select  unistr('\0660') from dual;

We are getting the Arabic numeral for 0..With out changing the database character set..How it is working...

Need your help...

This post has been answered by Etbin on Nov 28 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2013
Added on Nov 28 2013
10 comments
12,080 views