RE: Changing Character Set from WE8ISO8859P1 to UTF8

Oracle has an internal utility to do this in place named csconv. You have to get this from Oracle consulting. In any event, there is a utility named csscan in your oracle home. Run it against your database and it will tell what data if any needs to be changed. Look for UTF8 conversion docs on metalink. They have what you need there. A direct conversion using the alter database commnad will corrupt data if not everyting in your database is convertible. You must do this to do the export import cycle or cssconv.

Allan

-----Original Message-----
Tanel Poder
Sent: Monday, December 15, 2003 4:54 AM
To: Multiple recipients of list ORACLE-L

You can't change to UTF8 from WE8ISO8859P1, since the latter is not a subset of UTF8. If you were on US7ASCII, the story would be different.

You have to go with export/import.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, December 14, 2003 6:19 AM

> I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed
> character set using alter database character set. It will work without

> any problem. Go for it.
>
>
> -----Original Message-----
> Sent: Saturday, December 13, 2003 9:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I am in the process of planning our upgrade for our 8.1.5 database to
> 8.1.7.4. This is the first step in upgrading all my databases to
> 9.2.0.4. As part of this upgrade I am changing the character set from
> WE8ISO8859P1 to
> UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER
> SET
> command? If so, was there any problems?
>
> Thanks,
>
> Sandra Arnold
> Principal DBA
> NCI Information Systems
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arnold, Sandra
> INET: ArnoldS_at_OSTINET.osti.gov
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pandian, Thiru
> INET: Thiu.Pandian_at_il.proquest.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information.  Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer.  This email may have been monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).