NLS-conversion hell.

From: Per-Arne Hellarvik <perarne_at_infostream.no>
Date: Fri, 28 Nov 2003 11:54:57 +0100
Message-ID: <FNFxb.316$7U1.1430@amstwist00>

I need to convert a database from NE8ISO8859P10 to UTF8.

I tried running csscan with terrible results: ~270.000 rows with lossy conversion. I can write some procs which does the conversion from the lossy conversion characters to legal chars. But I need to get a mapping between NE8ISO8859P10<->UTF8.

Maybe I'm missing out on something here, but I haven't found any such mappings on the net. And csscan just returns the first 30 chars of the lossy-row.

Anyone done something like this before?

-- 
¹²³ Beat me, Whip me, Make me use windows¡¿¡ ³²¹

 Per-Arne Hellarvik         Infostream Services
 Senior DBA                 (+47) 98215572
 perarne@infostream.no      http://www.infostream.no

.oO°Oo. Geek by nature, Linux by choice! .oO°Oo.

Received on Fri Nov 28 2003 - 04:54:57 CST