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...