Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> exp data from WE8ISO8859P1 and imp in UTF8

exp data from WE8ISO8859P1 and imp in UTF8

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 13 Aug 2002 15:52:13 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7027FCB1F@lnewton.leeds.lfs.co.uk>


Hannes,

bearing in mind that UTF8 is a multi-byte character set whereas the other one isn't, you might have problems (as I did) importing into the UTG8 from the WE8ISO one. The reason is that certain accented characters are converted from one byte in WE8ISO to two or more in UTF8.

There is a utility to help you test if there will be any problems with conversion, called the 'charcter set scanner' and it is documented in Oracle 8i documetation addendum manual (for 8.1.7 anyway). For Oracle 9 it is in the 'globalisation support guide'.

Have fun.

Regards,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: schuhb_at_gmx.at (Hannes Schuhboeck) [mailto:schuhb_at_gmx.at] Posted At: Tuesday, August 13, 2002 12:43 PM Posted To: server
Conversation: exp data from WE8ISO8859P1 and imp in UTF8 Subject: exp data from WE8ISO8859P1 and imp in UTF8

Hi,
I have to export data from the following DB <SNIP> Received on Tue Aug 13 2002 - 09:52:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US