Home » SQL & PL/SQL » SQL & PL/SQL » How to Change Language and characterset dynamically. (Oracle 10g)
How to Change Language and characterset dynamically. [message #304161] Tue, 04 March 2008 06:36 Go to next message
kk185057
Messages: 5
Registered: March 2008
Location: INDIA
Junior Member

Hi All,

New to this Forum... Please Dont mind if i dont follow the protocols for some time.. I am stuck up with one problem wherein i have to dynamically change the language and character set to Japanese to have the user see what he actually wants to see and not junk characters.

Tried this but did not get the desired result..
SELECT CONVERT('JP_żżżżż&żżżżżżżżżżżż_Migr ', 'JA16EUC', 'UTF8')
FROM DUAL;

Is there a way.. i can change the this thing while selecting like i can set the date language in TO_CHAR function.

Eg.
SELECT TO_CHAR(SYSDATE,'DD/MONTH/YYYY','NLS_DATE_LANGUAGE=''FRENCH''') FROM DUAL;


Thanks..
Kapil Kaushik
Re: How to Change Language and characterset dynamically. [message #304178 is a reply to message #304161] Tue, 04 March 2008 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't change the character set.

There is no excuse to not read OraFAQ Forum Guide when you know there is one.
To get rid of "Newbies should not post to this forum!" on forum description and to ignore Not an EXPERT? Post in the NEWBIES forum, NOT here sticky.

Regards
Michel
Re: How to Change Language and characterset dynamically. [message #304224 is a reply to message #304178] Tue, 04 March 2008 10:20 Go to previous messageGo to next message
kk185057
Messages: 5
Registered: March 2008
Location: INDIA
Junior Member


Begin
execute_immediate('ALTER SYSTEM SET NLS_CHARACTERSET='UTF8' SCOPE=SPFILE');
END;

and then again after using this set the char set back to original..

I tried this but my ERP system doesn't allow me to change SPFILE parameters. This is why i would require your kind help.

Thanks
Kapil Kaushik
Re: How to Change Language and characterset dynamically. [message #304230 is a reply to message #304224] Tue, 04 March 2008 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I tried this but my ERP system doesn't allow me to change SPFILE parameters.

Maybe because this parameter does not exist?

Regards
Michel
Re: How to Change Language and characterset dynamically. [message #304231 is a reply to message #304178] Tue, 04 March 2008 10:33 Go to previous messageGo to next message
kk185057
Messages: 5
Registered: March 2008
Location: INDIA
Junior Member

Sorry for posting in Expert Forum... i thought i m quite comfortable with this SQL/PLSQL stuff and enterd into the Pro Zone..

Next time onwards i will submit in New bee Forum.
Re: How to Change Language and characterset dynamically. [message #304232 is a reply to message #304231] Tue, 04 March 2008 10:36 Go to previous messageGo to next message
kk185057
Messages: 5
Registered: March 2008
Location: INDIA
Junior Member

It Does exist.. I checked NLS_DATABASE_PARAMETERS and also V$PARAMETER. It is just that i m not able to have some users see Japanese characters keeping all other users as normal.
Re: How to Change Language and characterset dynamically. [message #304233 is a reply to message #304232] Tue, 04 March 2008 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is an environment and database parameter it is NOT an instance (initialization) parameter.
And you'd know it if you read the error Oracle sent you:
ORA-02065: illegal option for ALTER SYSTEM


Regards
Michel
Re: How to Change Language and characterset dynamically. [message #304236 is a reply to message #304232] Tue, 04 March 2008 10:48 Go to previous messageGo to next message
kk185057
Messages: 5
Registered: March 2008
Location: INDIA
Junior Member

Thanks Michel.
Can anybody please suggest anything on this issue as to how can have the user see Japenese Characters.
i have tried Convert Function.. tried changing the NLS_LANG, NLS_LANGUAGE, NLS_CHARACTERSET but nothing seems to be working.

Thanks
Kapil Kaushik
Re: How to Change Language and characterset dynamically. [message #304238 is a reply to message #304236] Tue, 04 March 2008 10:54 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is because your client application does not understand or cannot display these characters.

Regards
Michel
Previous Topic: External Tables -- Identifying
Next Topic: Call from Java Plsql Procedure with VArray as Out Parameter
Goto Forum:
  


Current Time: Fri Feb 14 15:46:45 CST 2025