Home » SQL & PL/SQL » SQL & PL/SQL » Changing Character Sets in PL/SQL
Changing Character Sets in PL/SQL [message #261443] Wed, 22 August 2007 11:05 Go to next message
ronin10
Messages: 17
Registered: July 2007
Junior Member
Hi

Is it possible to change character sets within PL/SQL Code?

NLS_LANG : Japanese_Japan.UTF8 to American_America.UTF8

For example

I have a function (1) that eventually calls another function (2). When function 2 is called, I switch to character set American.America.UTF8.

Is this possible? Or is it only possible to set the character set in the Environment Variables?

Thanks.
Re: Changing Character Sets in PL/SQL [message #261448 is a reply to message #261443] Wed, 22 August 2007 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't want to change the character set (which is impossible) but language and territory.
This can be done with "alter session".

Regards
Michel
Re: Changing Character Sets in PL/SQL [message #261460 is a reply to message #261448] Wed, 22 August 2007 11:58 Go to previous message
ronin10
Messages: 17
Registered: July 2007
Junior Member
Thanks Michel
Previous Topic: spooling choice of columns as log file
Next Topic: Problem with data (too long query execution)
Goto Forum:
  


Current Time: Mon Dec 05 12:38:32 CST 2016

Total time taken to generate the page: 0.09196 seconds