SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_CHARACTERSET

543393Nov 1 2006 — edited Nov 3 2006

I'm having a problem with French accented characters, which I'm sure it's due to my lack of knowledge, so please be kind.

As I understand it, SQL*Plus command line uses the NLS_LANG entry from the Windows registry to determine the NLS_CHARACTERSET. So, for my local database, the setting is WE8MSWIN1252. Accented characters I insert using both SQL*Plus and SQL Developer all work fine and querying them shows the expected result.

Next I connect to a Solaris box from the same Windows PC. I change the NLS_LANG in the registry to be WE8ISO8859P1 to match the NLS_CHARACTERSET in the Solaris database. Accented characters I insert using SQL*Plus look fine in SQL*Plus and characters I insert using SQL Developer look fine in SQL Developer. However, querying the data in SQL*Plus that was inserted from SQL Developer and vice versa both show incorrect data.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2006

Added on Nov 1 2006

#sql-developer

3 comments

4,967 views