Forum OpenACS Q&A: Re: Problems with ISO-8859-1 character set (Bis, ter,...reptitas)
Also I wonder if this:
is a good idea. According to these excellent installation instructions: http://archive.greenpeace.org/~bruno/oracle.html it breaks the date formatting. You might want to try to change it to export NLS_LANG=.WE8ISO8859P1 and make sure that it really affects the nsd process. E.g. try starting aolserver from the commandline like this:
$ NLS_LANG=.WE8ISO8859P1 nsd -f -t yourconfig.tcl ...
And of course when testing a new configuration always try to insert _and_ read the newly inserted data after the restart. Don't rely on already existing data, it might be wrongly encoded.