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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help, i have to store diffrent Codepages in Oracle UTF8 with sqlldr and have to put them out via SQLPLUS in those different Codepages

Re: Help, i have to store diffrent Codepages in Oracle UTF8 with sqlldr and have to put them out via SQLPLUS in those different Codepages

From: Frank <fbortel_at_nescape.net>
Date: Tue, 09 Dec 2003 22:11:04 +0100
Message-ID: <br5d8q$jhq$1@news1.tilbu1.nb.home.nl>


Juelue wrote:

> Hallo to all,
>
> I use an Oracle 9i and i have to store different Codepages into UTF8
> Format:
>
> I load the data whith the sqlldr and set Characterset to MSWIN1250,
> MSWIN1251 and so on. I' ve got one Record with all 256 values in
> Hexadecimal. (x'01' to X'FF')
> If i select the stored Data, i get not all 256 Byte korrekt.
>
> Does anybody know what to do ?

Change the Client characterset to UTF8, MSWIN1252 or MSWIN1251, depending on which codepage you select

-- 
Regards, Frank van Bortel
Received on Tue Dec 09 2003 - 15:11:04 CST

Original text of this message

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