Re: UTF8 Characters Loaded With SQLLDR

Be wary of how things display - as this is affected by environment settings and font availability. Best to check the raw characters in the file and in the database using the unix od command and the SQL dump() function to see what is really there and in what characterset.

Bear in mind that if necessary you can set NLS_LANG differently in the client than the server setting and Oracle will automatically convert charactersets where possible. So for example you may want to consider setting your client (Linux?) NLS_LANG to match your Linux locale as fonts are usually in the old single-byte charactersets (ISO8859) which gives issues displaying multi-byte UTF8 characters.

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.
Received on Thu Dec 18 2003 - 02:27:11 CST