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!

how to insert arabic&english from oracle clients like TOAD,SQL*PLUS

244680May 15 2002

Hi
iam trying to insert arabic&english data from TOAD&SQLPLUS.
if i try to insert arabic by copy and paste iam getting ???? and
if i try to insert through my keyboard (after updating my system with regional
settings) iam able to type some junk characters.
I have installed Oracle 8.1.6 with characterset set to UTF8 and
in my client NLS_LANG settings i have tried with different settings like:-

AMERICAN_AMERICA.UTF8
AMERICAN_AMERICA.AR8MSAWIN
ARABIC_UNITED ARAB EMIRATES.UTF8
ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

i have also updated INIT.ORA nls_language ='ARABIC'.

but still iam getting same problem.
any help in this appriciated.
Thanks
Srinivas

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2002

Added on May 15 2002

0 comments

410 views