Home » SQL & PL/SQL » Client Tools » Sql Plus and unicode. (10G R2 Windows.)
Sql Plus and unicode. [message #444538] Mon, 22 February 2010 07:23 Go to next message
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.
Re: Sql Plus and unicode. [message #444545 is a reply to message #444538] Mon, 22 February 2010 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.

But this is the way to do it until Windows supports Unicode code page.

Regards
Michel
Re: Sql Plus and unicode. [message #444547 is a reply to message #444545] Mon, 22 February 2010 07:58 Go to previous messageGo to next message
JuicyFruit
Messages: 34
Registered: September 2009
Member

So there is no other way to do it on Windows platform?
Re: Sql Plus and unicode. [message #444552 is a reply to message #444547] Mon, 22 February 2010 08:10 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No safe way I am aware of.

Regards
Michel
Previous Topic: ECHO ON/OFF
Next Topic: SQL Select with variables (merged by CM)
Goto Forum:
  


Current Time: Thu Sep 29 03:52:21 CDT 2016

Total time taken to generate the page: 0.06657 seconds