ORACLE7 converts Skandinavian letters to '??????..'

I have problem with skandinavian letters. When I insert or update a text field with data that includes skandinavian letters, all skandi-letters are replaced with '?' when I next time look at that data. This happens when I'm using client on WinNT. So when I manipulate data in Windows this conversion to '?' happens... But If I do this in unix, I can insert skandi-letters too.

The oracle is installed with NLS_LANGUAGE=american. Does this mean that oracle filters all skandi-letters when inserting and updating happens? I don't understand why I can insert the same data when I'm doing it in unix?!?

It doesn*t matter if I'm using ODBC or native oracle database drivers in windows, oracle always converts letters to '?'.

I would be very grateful if somebody could give some kind of help what's wrong with my system..:)

Kari Kinnunen
Sanoma Inc.
Helsingin Sanomat
kari.kinnunen_at_sanoma.fi Received on Sat May 18 1996 - 00:00:00 CEST