We will convert DB from we8iso8859p15 to UTF8 character set due to Greek implementation.

The import failed for around 56 tables with "ORA-01401: inserted value too large for column" error message by Oracle exp/imp.

Can anyone help?

hi joshu,

five weeks ago, I had to convert russian texts from one character coding into another (no database but good old excel problem). My solution was to use perl.

I guess you have at least perl and a C compiler on your hp-ux boxes; the rest could be found on CPAN (www.cpan.org).

Some basics from my problem, but I think you get the idea:


#!/usr/local/bin/perl

use Unicode::Map8;

# Map Unicode into Codepage 1251
my $map = Unicode::Map8->new("cp1251") || die;

# now, we have data in $ustr containing Unicode characters 04xx
# and we want to convert it to CP-1251.
$lstr = $map->to8($ustr);



Hope that helps,
günther