Message-Id: <10493.105351@fatcity.com> From: "Walter K." Date: Wed, 10 May 2000 16:05:09 -0500 Subject: WE8ISO8859P1 vs. UTF8 Character Sets This is a multi-part message in MIME format. ------=_NextPart_000_00AF_01BFBA99.8428C410 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_00AF_01BFBA99.8428C410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I'm trying to populate a table for a = data warehouse=20 I am developing. The source database is

8.0.4 with WE8ISO8859P1 as the = character set. The=20 target database is 8.1.6 with UTF8 as

its character set.

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 from the source table to the = target table.=20 I have identified the PO_NUMBER

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 set for this = column=20 during the insert but still no luck.

I looked through the historical posts I = have for=20 this listserv and I saw a post that said WE8ISO8859P1

is a subset of UTF8 and therefore = anything stored=20 in WE8ISO8859P1 can be stored in UTF8. If this is the

case, why am I getting this error=20 still?

Any suggestions would be = appreciated.

-w

------=_NextPart_000_00AF_01BFBA99.8428C410-- __________________________________________________ Do You Yahoo!?