Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
nls settings
4 views
Skip to first unread message
hk
Feb 3, 2012, 3:04:34 PM2/3/12
to
Hi,
I have a 11.2 database with the following settings:
NLS_CHARACTERSET EE8MSWIN1250
NLS_NCHAR_CHARACTERSET AL16UTF16
Is there any way I could insert all french accented characters into
this database or the nls_characterset forbids that, even if the
nls_nchar_characterset can handle french accents? I created a test
table with one nvarchar2 column, but there are characters that lose
their accent after creation. (è for example).
Thanks,
hk
I have a 11.2 database with the following settings:
NLS_CHARACTERSET EE8MSWIN1250
NLS_NCHAR_CHARACTERSET AL16UTF16
Is there any way I could insert all french accented characters into
this database or the nls_characterset forbids that, even if the
nls_nchar_characterset can handle french accents? I created a test
table with one nvarchar2 column, but there are characters that lose
their accent after creation. (è for example).
Thanks,
hk
ddf
Feb 3, 2012, 4:40:57 PM2/3/12
to
settings so check the local settings (Oracle and O/S) on the client
machine. Oracle will convert characters to the destinaton character
settings on the client, even for NVARCHAR2 columns (if I remember
correctly). You may need to adjust the Oracle client settings or the
Windows codepage to resolve UTF8/UTF16 characters correctly.
David Fitzjarrell
0 new messages