cancel
Showing results for 
Search instead for 
Did you mean: 

Character set conversion 9i

Former Member
0 Kudos

Dear all experts,

i encountered problem when i tried to change national character set and database character set according to note 102402 and 66902 both get this error:

ORA-12714: invalid national character set specified

when altering the database to UTF8(in note 66902) and to WE8DEC(in note 102402).

Any advice on this matter?

thank you in advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

My hunch is right. apparently there is only 4 entries in V$NLS_VALID_VALUES. so how to populate correct content if it is even possible?

content:

LANGUAGE AMERICAN

TERRITORY AMERICA

CHARACTERSET US7ASCII

SORT BINARY

Any advise on this?

Former Member
0 Kudos

also i got really weird feeling like UTF8 and other character sets not exist, is there a way to confirm what is valid character set(ORA-12714: invalid national character set specified)? or what character set exists(the schema or table)? since it is strange for both command not work with the same error:

1. alter database character set WE8DEC;

2. ALTER DATABASE NATIONAL CHARACTER SET UTF8;

Former Member
0 Kudos

Here I suggest to plan your Oracle upgrade immediately.

On your initial question - Search SDN/Google with ORA error code

Regards,

Nick Loy

Former Member
0 Kudos

yes it is part of database upgrade, by guide(from marketplace) at setting environment part there is "change national character set and database character set to UTF8/WE8DEC(recommended )" . Can i interpret your suggestion as upgrade first, convert later?