Oracle Text (MOSC)

MOSC Banner

chinese charset always be showing with '????' in a query

edited Mar 18, 2014 12:00PM in Oracle Text (MOSC) 2 commentsAnswered

I installed a oracle database at my Win7 laptop.

Currently, my oracle database has below information:

select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from

(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,

(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,

(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

It returns "AMERICAN_AMERICA.WE8MSWIN1252".

My Win7 is a English version. No any chinese charset installed.

I access register: HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME   NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

I create a table and insert some chinese at its columns. But I always get "????" at these columns after query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center