How to Change Language and characterset dynamically. [message #304161] |
Tue, 04 March 2008 06:36  |
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
|
|
|
|
|
|
|
|
|
|
|