Re: NLS_LANG

Gerard H. Pille wrote:
Alas, we want to check if all PC's have been correctly configured, even all clients.

As far as i know, it can't be done from within the Oracle server.
I guess, it should be done by os means, another difficulty may be in the term environment *variable*, i.e., it can be changed
every time by the client.

Indeed, and we would like to prevent that. A client pretending to use the same character set as the database, can store quite
some rubbish.

*sigh* You are so right about this.

Of course it is sometimes correct to have client encoding
equal to server encoding, and there's no way to verify on
the server side whether that is correct or not. There is not
even a way to find out what the client encoding is.

I personally think that Oracle made two mistakes (I'd call
them bugs):

- They do not verify correctness of the data when client
encoding is equal to serve encoding.

- They do not report an error when a character conversion
between different encodings fails, but silently store
bad data ("replacement characters").

This all comes together with a third bug, namely that
(at least up to Oracle 8) Windows clients were installed
with the wrong NLS_LANG setting (WE8ISO8859P1) by default.

All this resulted in lots of corrupt databases.

Yours,
Laurenz Albe


.

Relevant Pages

  • Re: problem connecting to db.
    ... the server and the client are at the same machine (the process is ... The VB6 client and the server are on the same machine, ... Oracle server software using one, and the Oracle client using the ... Look at the services on the server to verify that the Oracle Listener ...
    (comp.databases.oracle.misc)
  • Re: POSTing Chinese characters
    ... your claims of POST'd data experiencing encoding problems does ... Character encoding of data on the client side ... Server locale ... it seems that your issue is a Pocket IE issue. ...
    (microsoft.public.inetserver.iis)
  • Re: problem connecting to db.
    ... Have you checked the listener log file on the database server? ... client is correct, and that the connection string that you are ... the Oracle client would be looking for a server ...
    (comp.databases.oracle.misc)
  • RE: Help Needed: DBI (no error string)
    ... > error on the server. ... You can also turn on tracing in dbi and at the sqlnet level to ... > Thanks for letting me know abt the oracle 9i client issue. ...
    (perl.dbi.users)
  • Re: ODBC-error ORA-12535: TNS:operation timed out when trying to connect to Oracle 9.2.0
    ... I'm trying to connect to an Oracle 9.2 database via TCP from Microsoft ... Microsoft Windows Server 2003 SP1 ... Try with SQL*Plus on your client! ...
    (comp.databases.oracle.misc)