How to interpreted UTF8-especially GREEK charset if DB side 10G is set to NLS_LANG is CL8MSWIN1251

ivber

Member
PL/SQL Developer > Preferences > Оptions is checked - "Unicode enabled". When try to insert into table with columns data type set to nvarchar2 using UTF8 charset,then GREEK characters as layouts are OK - visible by select query.
Please, urgent help - how to use UTF8 charset in my application program. I set UTF8 charset on client side WinXP registry - NLS_LANG=AMERICAN_AMERICA.UTF8 and export NLS_LANG=AMERICAN_AMERICA.UTF8 on DB side - Oracle10G. When try by my program to insert GREEK characters into nvarchar2 columns - layouts are invalid mismatches:

2 Αν προτιμάτε να εφαρμόσουν υποστήριξη Unicode
3 проба ???????? ????????? ?????????? ?????

How works this Unicode enabled option?

 
The character sets you have defined do not apply to NVARCHAR2 columns, but rather to VARCHAR2 and other standard character data types.
 
Back
Top