Re: Oracle 11 Server and Unicode UTF-8
Date: Fri, 28 May 2010 10:57:34 +0200
Message-ID: <hto0i0$tku$1_at_news.eternal-september.org>
Hi Walt,
yes, every field with too much characters (more than 4000 bytes UTF8 code) can not be converted without data loss. It could be more secure to add new Unicode columns if you have already database with data in it and then add conversion programs.
Arne Ortlinghaus
ACS Data Systems
"Walt" <walt_askier_at_SHOESyahoo.com> schrieb im Newsbeitrag
news:G8zLn.326559$Up1.229692_at_en-nntp-09.dc1.easynews.com...
> Hi,
>
> 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 conversion
> and what pitfalls to watch out for. Any suggestions?
>
> One thing I expect to be a problem is that we have about 200 columns that
> are defined as Varchar2(4000). My understanding is that this limit is
> 4000 *bytes* so some of our data may not "fit" if it contains enough
> characters with ascii values above 128.
>
> Anyone been through this before who'd like to offer sage advice?
>
> Thanks.
>
> //Walt
Received on Fri May 28 2010 - 03:57:34 CDT