Oracle Database Discussions

Hi,
I'm working win Win XP (French regional Settings), Oracle Client 11g with NLS_LANG set for France.
I'm seeing that when I retrieve the grouping separator numbers char from the regional settings popup (within Control Panel)
and I execute the following within the database I have the following results:

SQL> select ascii(' ') from dual;

ASCII(' ')
----------
49824

SQL>

between the '' there is the grouping separator numbers char.

When I try to execute the following ALTER session:

ALTER SESSION SET NLS_NUMERIC_CHARACTERS=' ,' (where the first blank space is char(49824))

I have an error for which NLS_LANG is invalid. If I change char(49824) in char(32) it works.

Do you know a reason for which instead od the standard blank space chr(32) we have chr(49824) for french settings?

thanks
Umberto