Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |