This is a multi-part message in MIME format.
------=_NextPart_000_01A5_01BFBB6E.3884D7D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Revision: The datatype/length for PO_NUMBER is varchar2(50), not NUMBER. =
- Original Message -----=20
From: Walter K.=20
To: Multiple recipients of list ORACLE-L=20
Sent: Thursday, May 11, 2000 1:44 PM
Subject: WE8ISO8859P1 vs. UTF8 Character Sets
Hi,
I'm trying to populate a table for a data warehouse I am developing. =
The source database is
8.0.4 with WE8ISO8859P1 as the character set. The target database is =
8.1.6 with UTF8 as
its character set.
The problem I am encountering is I am getting an ORA-01401 (inserted =
value too large for column) when trying to do an INSERT...AS SELECT from =
the source table to the target table. I have identified the PO_NUMBER
column as the source of the problem. The datatype/length of the source =
and the target columns are both NUMBER with no precision or scale is =
specified. I tried using the CONVERT( ) function to translate the =
character set for this column during the insert but still no luck.
I looked through the historical posts I have for this listserv and I =
saw a post that said WE8ISO8859P1
is a subset of UTF8 and therefore anything stored in WE8ISO8859P1 can =
be stored in UTF8. If this is the
case, why am I getting this error still?
Any suggestions would be appreciated.
-w
------=_NextPart_000_01A5_01BFBB6E.3884D7D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Revision: The datatype/length for =
PO_NUMBER is=20
varchar2(50), not NUMBER. </FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:alden14004_at_yahoo.com" =
title=3Dalden14004_at_yahoo.com>Walter K.</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, May 11, 2000 =
1:44=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> WE8ISO8859P1 vs. UTF8 =
Character=20
Sets</DIV>
<DIV><BR></DIV>
<DIV style=3D"FONT: 10pt arial"></DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to populate a table for a =
data=20
warehouse I am developing. The source database is</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>8.0.4 with WE8ISO8859P1 as the =
character set. The=20
target database is 8.1.6 with UTF8 as</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>its character set.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>The problem I am encountering is I am =
getting an=20
ORA-01401 (inserted value too large for column) when trying to do an=20
INSERT...AS SELECT </FONT><FONT face=3DArial size=3D2>from the source =
table to the=20
target table. I have identified the PO_NUMBER</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>column as the source of the problem. =
The=20
datatype/length of the source and the target columns are both NUMBER =
with no=20
precision or scale is specified. I tried using the CONVERT( ) function =
to=20
translate the character </FONT><FONT face=3DArial size=3D2>set for =
this column=20
during the insert but still no luck.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I looked through the historical posts =
I have for=20
this listserv and I saw a post that said WE8ISO8859P1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>is a subset of UTF8 and therefore =
anything stored=20
in WE8ISO8859P1 can be stored in UTF8. If this is the</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>case, why am I getting this error=20
still?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestions would be=20
appreciated.</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>-w</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_01A5_01BFBB6E.3884D7D0--
Received on Thu May 11 2000 - 17:27:45 CDT