Hello everyone,
I have a problem about charsets. A customer of mine has a database with WE8ISO8859P9 charset (europe and turkish charset) and NLS_NCHAR_CHARACTERSET is AL16UTF16:
SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET';
NLS_CHARACTERSET WE8ISO8859P9
NLS_NCHAR_CHARACTERSET AL16UTF16
Using company application, users copy some text from microsoft word and past into application and this data is inserted into a CLOB column. In this data there are double quotation marks but microsft curly double quotation mark, which is: “ as I checked from word this is Unicode char with char code : 201C
so this char is inserted as a question mark.
create table tmp33 (f1 varchar2(100), f2 nvarchar2(100), f3 clob, f4 nclob);
insert into tmp33 values ('“','“','“','“');
select * from tmp33;
result is:
? ? ? ?
is this because of WE8ISO8859P9 or AL16UTF16 is not support this char or oracle client nls params is not support and I can not send this char to oracle ?
db version is:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
thanks
Message was edited by: Mustafa KALAYCI
Message was edited by: Mustafa KALAYCI, change the subject.