OraFAQ Forum: Client Tools » Sql Plus and unicode.

Home » Other » Client Tools » Sql Plus and unicode. (10G R2 Windows.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Plus and unicode. [message #444538]

Mon, 22 February 2010 07:23

JuicyFruit
Messages: 34
Registered: September 2009

Member

Hello everyone!

What I need to do:

I have database with:

NLS_CALENDAR	GREGORIAN
NLS_CHARACTERSET	AL32UTF8
NLS_COMP	BINARY
NLS_CURRENCY	$
NLS_DATE_FORMAT	DD.MM.RR HH24:MI:SS
NLS_DATE_LANGUAGE	AMERICAN
NLS_DUAL_CURRENCY	$
NLS_ISO_CURRENCY	AMERICA
NLS_LANGUAGE	AMERICAN
NLS_LENGTH_SEMANTICS	CHAR
NLS_NCHAR_CHARACTERSET	UTF8
NLS_NCHAR_CONV_EXCP	FALSE
NLS_NUMERIC_CHARACTERS	.,
NLS_SORT	BINARY
NLS_TERRITORY	AMERICA
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR

Is it possible to insert data using SQLPLus executing some script insert.sql, where data is represented in different languages?
e.g I need to insert into one table data in english, to other table data in russian and so on, but all in one session.

I can change NLS_LANG parameter and code page of cmd.exe where sqlplus is runing before changing insert language, but it's not so good.

Report message to a moderator