There are two potential problem levels here:
The character set of the PC, and the characterset as defined by Oracle. If
you are using the standard 437 code page you won't get diacritical
characters in AFAIK.
Then there is the issue of setting NLS_LANG in the registry.
If this has not been done, the characterset will default to US7ASCII,
regardless the settings of the PC.
There are several dictionary views dealing with nls settings
nls_session_parameters
nls_database_parameters
and nls_instance_parameters.
From the top of my head, the first one reflects the client settings in the
registry.
Hth,
Sybrand Bakker, Oracle DBA
cocoa1826_at_my-dejanews.com wrote in message
<7ga2d3$n95$1_at_nnrp1.dejanews.com>...
>Is there anyway to determine the charset of a client from within a session?
>The server's charset can be determined with a query like: select value
from
>v$nls_parameters where parameter = 'NLS_CHARACTERSET' I want to compare to
>the client's.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
Received on Thu Apr 29 1999 - 14:23:36 CDT
