Database Administration (MOSC)

MOSC Banner

how to insert japanese character

edited Jun 1, 2009 7:18PM in Database Administration (MOSC) 3 commentsAnswered
Hi,

I have an user request to insert japanese character, but when i try insert into database using sqlplus it cause error and insertion failed.

Below is my database nls parameters:

PARAMETER                                       VALUE
==========                                         ===========
NLS_LANGUAGE                                AMERICAN
NLS_TERRITORY                                 AMERICA
NLS_CHARACTERSET                      WE8ISO8859P1
NLS_NCHAR_CHARACTERSET      AL16UTF16

Which table column datatype is supported for Japanese character?

Appreciate of any input given

Thanks

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