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

kari.kinnunen_at_sanoma.fi wrote:
: 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?!?

[SNAP !]

1. Make sure that the database is created with a 8-bit character set (e.g. we8iso8859-p1) wich contains the scandinavian letters (this seems to be the case since you can use the chars on the unix (server i presume) side.
2. Make sure that the NLS_LANG enviroment parameter is properly set on the client. The important aspect here is that the character set is set to an 8 bit set (e.g. NLS_LANG=american.america.we8iso8859-p1).

This should cure the problem.

/Jacob

--
Jacob Steen Due                              RAMBOLL Informatics and Management 

email: jcd_at_ramboll.dk

'The opinions expressed by me are my own, not my employers - I think'