xlcwas0
7th May 2015, 04:22
hello,
I have a probelm about get chinese text field from table tttxt010 and the value are all unrecognizable character,but other table I can get chinese character normally.

server database:oracle
tool:PL/SQL
-------------------------------------------------------
select * from nls_database_parameters;

PARAMETER VALUE
1 NLS_LANGUAGE ENGLISH
2 NLS_TERRITORY GERMANY
3 NLS_CURRENCY ?
4 NLS_ISO_CURRENCY GERMANY
5 NLS_NUMERIC_CHARACTERS ,.
6 NLS_CHARACTERSET WE8MSWIN1252
7 NLS_CALENDAR GREGORIAN
8 NLS_DATE_FORMAT DD.MM.RR
9 NLS_DATE_LANGUAGE ENGLISH
10 NLS_SORT BINARY
11 NLS_TIME_FORMAT HH24:MI:SSXFF
12 NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
13 NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
14 NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
15 NLS_DUAL_CURRENCY ?
16 NLS_COMP BINARY
17 NLS_LENGTH_SEMANTICS BYTE
18 NLS_NCHAR_CONV_EXCP FALSE
19 NLS_NCHAR_CHARACTERSET AL16UTF16
20 NLS_RDBMS_VERSION 11.2.0.2.0


----------------------------------------------------

thanks.