Multi-byte characters not displaying in data grid.

[Atl_Chris]

I have a test table defined as follows:
create table CLH_VARCHAR
(
VARCHAR_COL VARCHAR2(100),
NVARCHAR_COL NVARCHAR2(100)
)

Our database charactersets are:
1 NLS_NCHAR_CHARACTERSET AL16UTF16
2 NLS_CHARACTERSET WE8ISO8859P1

I run the following inserts:
insert into clh_varchar values('h1','孙');
insert into clh_varchar values('he','

 

[Marco Kalter]

You will need to set the client character set (NLS_LANG) to _.UTF8 of you want to use Unicode characters in SQL or PL/SQL code.

 

[Atl_Chris]

Thanks, I've set the NLS_LANG in the registry to : AMERICAN_AMERICA.UTF8 . The character is still not inserting and displaying as expected. Should that work for what I'm trying to test or do I need to set it to a Chinese language_territory?
I'm new to the multibyte characterset arena and appreciate your assistance.
Thanks,
Chris

 

[Marco Kalter]

It should work, regardless of language and territory. What is your PL/SQL Developer, Database and Client version?

 

[Atl_Chris]

I copied this info from the pl/sql developer support information.
Thanks,
Chris

PL/SQL Developer
Version 7.1.5.1398
01.52701 - 30 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2,086,956 kB (1,051,856 available)
Paging file : 4,025,084 kB (3,166,476 available)
Virtual memory : 2,097,024 kB (1,950,772 available)

Preferences
Session mode: Multi
OCI Library: C:\oracle\product\10.2.0\client_1\bin\oci.dll
Use OCI7: False

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

 

[orca777]

Hi,
additionally set in your registry in the correct oracle home folder :

ORA_NCHAR_LITERAL_REPLACE=TRUE

additional with the UTF8 settings i could process Unicode literals which you have also to prefix with N : N'uString'

kind regards
Karl

 

[Atl_Chris]

Thank you! That resolved the issue.