Re: changing character sets - twice??

Joel,

You can only change the character set if the character set you are changing TO is a superset of the one you are changing FROM. For instance, the WE8ISO8859P1 contains all of US7ASCII plus some additional "characters". But all of WE8ISO8859P1 is not in US7ASCII. So you can go from US7ASCII -> WE8ISO8859P1 but not back!

HTH,
Brian

Joel Green wrote:
>
> Hello,
>
> Changing a character set on an 8.0.6 Oracle DB worked, but now it
> won't change to anything else!
>
> The character and national character sets were set to US7ASCII. They
> were then changed to WE8DEC.
>
> I did:
> SVRMGR> connect sys as sysdba;
> SVRMGR> shutdown immediate
> SVRMGR> startup mount
> SVRMGR> alter system enable restricted session;
> SVRMGR> alter system set job_queue_processes = 0;
> SVRMGR> alter database open;
> SVRMGR> alter database character set WE8DEC;
> SVRMGR> alter system disable restricted session;
> Also changed the national character set.
>
> This worked fine.
>
> However, when I do the same, but change back to US7ASCII, or UTF-8 (or
> anything else), it says:
>
> SVRMGR> alter database character set US7ASCII;
> alter database character set US7ASCII
> *
> ORA-24329: invalid character set identifier
>
> Both UTF-8 and US7ASCII show up with the query:
> SELECT parameter,value
> FROM v$nls_valid_values
> WHERE parameter = 'CHARACTERSET'
> ORDER BY value;
>
> Which is baffling me :-)
>
> Joel
Received on Tue Nov 20 2001 - 12:39:30 CST