Re: Oracle 11 Server and Unicode UTF-8
Date: Fri, 28 May 2010 13:39:15 -0700 (PDT)
Message-ID: <bd851c51-2bc7-42eb-9af7-d5b7e76738d3_at_f13g2000vbm.googlegroups.com>
On May 27, 8:49 pm, Walt <walt_ask..._at_SHOESyahoo.com> wrote:
> We're running Oracle 10g on Windows using ISO 8859 as the character set.
> We're exploring the idea of converting to unicode (UTF8) along with the
> upcoming upgrade to v11.
>
> I haven't found a good reference for how to best accomplish the
These topics are well covered for example on Metalink / MOS - good references / starting points can be found in the following documents:
788156.1: AL32UTF8 / UTF8 (Unicode) Database Character Set
Implications
260192.1: Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode)
These notes also describe how to get an overview of invalid / lossy / truncations due to the character set conversion - the tool to use is CSSCAN which will scan the data and generate corresponding reports.
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
Co-author of the "OakTable Expert Oracle Practices" book: http://www.apress.com/book/view/1430226684 http://www.amazon.com/Expert-Oracle-Practices-Database-Administration/dp/1430226684 Received on Fri May 28 2010 - 15:39:15 CDT