"Jeff Strickland" <jeffstr@hotmail.com> wrote in message
news:%rVxb.307243$pT1.144048@twister.nyc.rr.com...
> Hello all,
>
> I am having a problem with a data migration from SQL Server to Oracle 9i
> using DTS and am running out of things to try.
>
> The problem arises when I attempt to transfer non-english characters such
as
> " é ". The error message I get is ORA-01401: inserted value too large for
> column.
>
> The source is SQL Server 2000, data type is nvarchar 32. The target is
> Oracle 9i, data type is char 32.
>
> I have tested the following:
> - changing the target data type to varchar - this works but is not a
> realistic option
> - trimming the sent data down to less than 10 characters - did not work
> - using OLE-db and ODBC - did not work
> - using Microsoft's and Oracle's ODBC drivers - did not work
> - transferring first to a csv file then to Oracle - did not work
> - transferring first to an Excel file then to Oracle - did not work
> - entering a test value manually into the Oracle table using Toad - worked
>
> I would appreciate any suggestions or insights into this problem.
>
> Thanks,
> Jeff Strickland
>
>
>