I cannot get the Swedish Characters to work correctly

[Daniel Jensen]

Heeeelp..

Im having a problem with sqlload in Oracle.
The sqlloader loads data from a fil into the database via a shell script.
The shellscript somehow translates the swedish characters "sS?" into crap when running sqlloader (at least that is what i think).
The Database DO handle swedish characters for example when updating columns via sql worksheet in Enterprice manager so that is not the problem.

What parameters must be set to handle swedish charachters CORRECTLY ....?

I have tried to set all kinds of LC and LANG variables, but the only thing that happens is that i can write the characters at the window, but when I try to save it in any file it translates the characters into crap.

Pls...need help :-)

[Alex Glennie]

From the HP side : you'llmost likely need to set LANG= in the Users .profile, along with stty settings of cs8 -istrip & parenb.

If using CDE or VUE be aware that if you su via hpterm, dtterm or xterm without the loginShell resource or -ls command option your .profile will not be sourced as the new user and consequently any enviroment variables in your shell may not be carried over to the new shell. etc

Lastly I believe on the Oracle side there's also an enviroment variable : NLS_LANG= which needs also to be set, presumably to something like : Swiss_Swiss.weiso8859p1 but check with Oracle support for exact syntax, I do not have access to an Oracle system at present.