Re: SQL*Loader and german umlaut

From: Eltschinger Markus <test_at_test.com>
Date: Wed, 5 Mar 2003 12:43:27 +0100
Message-ID: <1046864611.327234@exnews>

Hello Tino,

I suppose your Oracle database was created with the characterset to support the data you want to load!
The parameter CHARACTERSET tells SQL*Loader what characterset should be used for your input file.

Here's an excerpt of an SQL*Loader control file (english MS Windows environment, client code page is WE8MSWIN1252):

OPTIONS (ERRORS=9999999, ROWS=1000, BINDSIZE=1000000) LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE *
REPLACE
INTO TABLE T_DUMMY
FIELDS TERMINATED BY ';'
TRAILING NULLCOLS
...

More infos about characterset migration you'll find also in "Oracle9i Database Globalization Support Guide".

Kind regards,
Markus Eltschinger

---

Swisscom IT Services Ltd
Data Warehouse Development
1752 Villars-Sur-Glâne FR
Switzerland
http://www.swisscom.com/it/content/index_EN.html

"Tino Korth" <korthNOSPAM_at_mhr.de> wrote in message news:b44j9j$jhg$1_at_ngspool-d02.news.aol.com...
> hello,
>
> i've written a perl script that creates a oracle-instaöll-script of a mysql
> database.
> my problem is, that german umlauts are malformed in the oracle database.
> how can i say sql*loader that there are german umlauts in the data files (i
> put ascii data files with sql*loader into the oracle database).
>
> can i set something in the sql*loader control file?
>
> thanks for reply!
>
>
> greetz from rostock, germany!
>
> tino
>
>
Received on Wed Mar 05 2003 - 05:43:27 CST