Re: Transfer "Accesscode" column from flat file into Oralce table

Harald Maier <maierh_at_myself.com> writes:

> rooty_hill2002_at_yahoo.com.au (Gary) writes:
>
>> Hi! guys,
>>
>> I have a flat file exported from an Informix database table. There is
>> a column called "accesscode" stores encrypted internet access codes
>> (in Informix, it is in varchar type), e.g. something looks like
>> "ëàòä".
>
> Try to set the environment variable NLS_LANG for the sql loader
> process. E.g.
>
> NLS_LANG=english_australia.we8iso8859p1
>

You can also specify the character set in the control file:

,----[ sqlldr ctl ]

| load data
| characterset we8dec
| infile *
| into table nls truncate
| fields terminated by whitespace
| (id)
| begindata
| Ödland
| Überkingen
| Güglingen

Harald Received on Thu Aug 28 2003 - 00:47:38 CDT