any one got an sql loader characterset example please ?

[Advocate]

first time to load non-english characters (legacy system data transfer) ...

german characters not correct after loading via sql-loader

ie german o with 2 dots appearing as small v

need to load german character datafile into database using WE8ISO8859P15 setting

can not find any examples on web so far
queries from research so far ...

should i initialise nls_lang in unix script ?

should i set characterset keyword in sql-loader control file ?

any other tips please ?
tanx in advance ...
Best of Irish Luck, David.
djwilkes@hotmail.com

 

[sem]

Your file encoding should correspond to NLS_LANG environment variable. Then the text is converted to the database charset (did you see a number of .NLB files?).
Though, some symbols may not be DISPLAYED correctly, if using another NLS_LANG or locale. You may check how they're stored internally using DUMP command. Regards, Dima

 

[Advocate]

fixed ... thanks dima ...

set UNIX environment variable prior to running sql-loader :

export NLS_LANG = WE8ISO8859P15

amended UNIX sql-loader control file
inserted after load data :

characterset WE8ISO8859P15

found out hard way that WE8ISO8859P15 only available in later versions of 8i (includes euro symbol)

over and out ...
Best of Irish Luck, David.
djwilkes@hotmail.com