Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!newshub.sdsu.edu!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail
From: dbaplusplus@hotmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Converting database from US7ASCII to UTF8
Date: 12 Dec 2005 10:22:27 -0800
Organization: http://groups.google.com
Lines: 33
Message-ID: <1134411747.111785.76120@g49g2000cwa.googlegroups.com>
References: <1134327976.321632.326570@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 148.177.1.213
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1134411752 2347 127.0.0.1 (12 Dec 2005 18:22:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Dec 2005 18:22:32 +0000 (UTC)
In-Reply-To: <1134327976.321632.326570@f14g2000cwb.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=148.177.1.213;
   posting-account=Rsc_ew0AAADekMIc-dc4fPwmaOlJ6nox
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257573


dbaplusplus@hotmail.com wrote:
> I am on HP UNIX 11i using Oracle 9.2.0.5.
>
> I had a database in database character set  US7ASCII. I recently
> converted it to database character set UTF8. Since I do not have any
> nchar or nvarchar2 columns, national character set is irrelevant even
> though it was UTF8 to begin with.
>
> Export was done using NLS_LANG=3DAMERICAN_AMERICA.US7ASCII and  same
> setting was used for import.
>
> During import some rows got rejected because column lengths of some
> varchar2 column will not fit UTF8 chacater set. I know UTF8 needs more
> bytes if character is outside of ASCII. My question is since I had
> US7ASCII database to begin with, why my rows got rejected, since UTF8
> is a superset
> of  US7ASCII.
>
> Looking at failed rows generated during import, I did notice that some
> rows had characters such as =D6  (O with two .. on top),  R with a
> trademark on top of it. If my database character set was ASCII, how
> this character was inserted in the first place.  What is the meaning of
> US7ASCII if my database had these characters.
> All columns with error are varchar2 columns.
>
> Appreciate your insight.
>
> Thanks a lot.


Does any one hae insight in this? Apprecaite your answer.