This content has been marked as final. Show 4 replies
Pl elaborate what "troubles" your partners are having. Looks like your setup is correct and works as expected. Can you get a copy of the complete SQL Loader commands, control file contents and the errors that your partners are encountering ?
What is the data type of your columns and variables? VARCHAR2 or NVARCHAR2? CHAR or NCHAR? CLOB or NCLOB?
## Our hungarian partner has troubles with special characters.
We cannot help with so little information. If setting NLS_LANG to .EE8MSWIN1250 helped, then the partner's client environment may be set to .EE8MSWIN1250 as well and files encoded in AL32UTF8 do not load correctly. The partner's test to set NLS_LANG could have been flawed (e.g. a misspelled variable name) and this is why it did not helped. But I can only speculate.
I'm sorry for my delay but I was out of office the last days...
I'll try to get a copy of his loader scripts. The problem is that special characters (e.g. ő) are shown as unkown characters (wrong ?). For me it seems he only processes the first byte of the character...
We're only using VARCHAR2 datatype.
I'll also try to get more detailed information from his environment.