Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTF8 Characters Loaded With SQLLDR
Russ wrote:
> Hello:
>
> We are loading files with UTF8 Characters (such as İ and Ç)
> My CTL File has:
> LOAD DATA
> CHARACTERSET UTF8
> APPEND
> INTO TABLE EXT_STG_SPEND
> .... then the columns....
>
> We set NLS_LANG on Linux to
> export NLS_LANG=AMERICAN_AMERICA.UTF8
>
> In Oracle:
> NLS_LANGUAGE = AMERICAN
> NLS_TERRITORY = AMERICA
> NLS_CHARACTERSET = UTF8
> NLS_NCHAR_CHARACTERSET = UTF8
>
> When I run this SQLLDR, The string: "PC İÇİN ALINAN LİSANS BED." gets
> input into my table as "PC ¿¿ ALINAN L¿ANS BED."
>
> I know that my DB supports "PC İÇİN ALINAN LİSANS BED." because when I
> enter it by hand it can maintain it.....
>
> I have read countless articles on the subject to no avail....
>
> Any help or direction on where to look would be greatly appreciated.
>
> Thanks.
Change your PC's charset - it's probably ISO; guess WE8MSWIN1252 would do it (that would match your OS) - else UTF8 - just as the server
-- Regards, Frank van BortelReceived on Wed Dec 17 2003 - 14:52:15 CST