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

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

Here an test with two different charactersets:

,----[ we8iso8859p15 ]
| SQL> select * from nls;
|
| ID
| ------------------------------
| Ödland
| Überkingen
| Güglingen

`----

,----[ us7ascii ]
| SQL> select * from nls;
|
| ID
| ------------------------------
| Vdland
| \berkingen
| G|glingen

`----

Harald Received on Thu Aug 28 2003 - 00:36:08 CDT