Database Administration (MOSC)

MOSC Banner

Database characterset Issue.

edited Jun 9, 2015 10:01AM in Database Administration (MOSC) 3 commentsAnswered

SQL>  SELECT * FROM NLS_DATABASE_PARAMETERS WHERE  PARAMETER LIKE '%CHARACTERSET';

PARAMETER                      VALUE

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

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_CHARACTERSET               WE8MSWIN1252

MY DATABASE IS CREATED WITH ALL ABOVE  NCHAR_CHARACTERSET AND CHARACTERSET

We choose WESTERN EUROPEAN CHARACTERSET ( Initially we are ingesting only european langauges) .


we are trying to ingest some arabic character now using NVARCHAR2 .

If Im using linux machine  everything seems working perfectly. but the data is not displaying properly on windows. (not sure if I need to install something on window).

SQL> DESC TEST

NAME                NULL?    TYPE

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

A                            NVARCHAR2(255)

B                            NUMBER



If I trying to insert from windows, it gets broken

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