Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Change character set in existing db

522736Jul 12 2006 — edited Jul 13 2006

Hi guy

I have a question How can I make oracle accept Unicode I think the problem is I am using WE8MSWIN1252
I run this sql -- >
SELECT parameter, value FROM nls_database_parameters
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0

Is there any way That Could change if AL32UTF8.... I tried altering it

SQL> UPDATE nls_database_parameters SET value = 'AL32UTF8' WHERE parameter = 'NLS_CHARACTERSET';
UPDATE nls_database_parameters SET value = 'AL32UTF8' WHERE parameter = 'NLS_CHARACTERSET'
*
ERROR at line 1:
ORA-01733: virtual column not allowed here

any suggestion guys? I really dont know if changing 'NLS_CHARACTERSET' value to AL32UTF8 would solve my problem..

By the way I am Using oracle 10g. But I would appeciate it If you could give me a solution that supports oracle 8 above .... but any solution will do
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2006

Added on Jul 12 2006

#general-database-discussions

19 comments

2,679 views