| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> WE8ISO8859P1 vs. UTF8 Character Sets
This is a multi-part message in MIME format.
------=_NextPart_000_0055_01BFBB25.CBB1BB70 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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_0055_01BFBB25.CBB1BB70 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 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 warehouse=20
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 =
INSERT...AS=20
SELECT </FONT><FONT face=3DArial size=3D2>from the source table to the =
target table.=20
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 =
appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-w</FONT></DIV></BODY></HTML>
------=_NextPart_000_0055_01BFBB25.CBB1BB70--
 |
 |