Re: Need to convert database characterset from WE8ISO8859P1 TO AL32UTF8

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Fri, 26 Jan 2007 18:58:20 UT
Message-Id: <1169837900.29737.1171417527@webmail.messagingengine.com>

Check with these Metalink Notes

Note:260192.1 Changing WE8ISO8859P1/ WE8ISO8859P15 or WE8MSWIN1252 to (AL32)UTF8 with ALTER DATABASE CHARACTERSET
Note:225912.1 Changing the Database Character Set - a short overview
Note:119119.1 AL32UTF8 / UTF8 (unicode) Database Character Set Implications
Note:227330.1 Character Sets & Conversion - Frequently Asked Questions

HTH
GovindanK

On Fri, 26 Jan 2007 12:52:32 -0500, [1]"Sandeep Dubey" <dubey.sandeep_at_gmail.com> said:
> Hi all
>
> Platofrm: Oracle 10.2 on Linux 2.4
>
> I need to convert database characterset from WE8ISO8859P1 TO AL32UTF8.
> Following is a part of csscan output. Some application data is
> convertible. I have blob data in the application. It is nowhere
> reported whether it is covertinble or changless in the csscan output
> scan.txt file.
>
> Can I safely convert the database using csalter script? If yes, what
> will happen to application data in Convertible column?
>
> Or I must use export import? Problem is our production database export
> and import will take over 24 hours and we can not take that much down
> time.
>

......

> Thanks
>
> Sandeep
> --
> [2]www.freelists.org/webpage/oracle-l
>
>

References

mailto:dubey.sandeep_at_gmail.com
file://localhost/tmp/linkstmp/www.freelists.org/webpage/oracle

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 26 2007 - 12:58:20 CST