Re: NLS Database Parameters vs. NLS Instance Parameters

"qwerty" <qwerty_at_yahoo.it> a écrit dans le message de news:cp3sbj$j2t$1_at_lacerta.tiscalinet.it...
> > What do you mean? sysdate don't use a format, sysdate is a date.
> > Maybe you think of display format when you execute something like:
> > select sysdate from dual
> > In this case, this nls_session_parameters or v$nls_parameter you have
> > to search in to know the default output date format.
>
> Some time ago, someone told me that sqlnet (it was version 8) uses plain
> text to deliver information to the client, infact with a sniffer i was able
> to read the query executed and their results, in this case, the
> NLS_INSTANCE... parameters affect the format of such data and it can affect
> the application (mismatch between client and server configurations) it is
> correct???
>
>
> Best regards
>
>

Yes, with default settings you can clearly see the query and results with a sniffer. No, mismatch between client and server configurations cannot affect the application unless it uses implicit conversions which it should not.

Regards
Michel Cadot Received on Tue Dec 07 2004 - 14:00:27 CST