Database Software

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!

can we change the DB character set at session level

S.Naresh Kumar -OracleNov 3 2011 — edited Nov 3 2011

hi,

Please help me
when iam giving the alter session command iam getting the error:

SQL> ALTER SESSION set NLS_CHARACTERSE
T =WE8MSWIN1252;
ALTER SESSION set NLS_CHARACTERSET =WE8MSWIN1252
*
ERROR at line 1:
ORA-00922: missing or invalid

i need to enter Arabic names in using the xml file.

here i have two questions
1)is it is possible to set character set at session level. because my client is not allowing to bounce the database. DB version is 10.2.0.4

Right now my DB is in US7ascii

2)is this "WE8MSWIN1252" set supports Arabic.

Regards,
Naresh

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2011

Added on Nov 3 2011

#database-key-features, #globalization-support

5 comments

2,481 views