OraFAQ Forum: Server Administration » UTF8 character set conversion

Home » RDBMS Server » Server Administration » UTF8 character set conversion

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

UTF8 character set conversion [message #305405]

Mon, 10 March 2008 12:38

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have NLS_CHARACTERSET set to WE8ISO8859P1 and NLS_NCHAR_CHARACTERSET is AL16UTF16.

I want to convert the nls characgterset to UTF8 to support multi language and wonder whether I have to convert the NLS_NCHAR_CHARACTERSET also to UTF8 or i can leave as it is.

Thanks,
GK

Report message to a moderator

Re: UTF8 character set conversion [message #305408 is a reply to message #305405]

Mon, 10 March 2008 12:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't care about NLS_NCHAR_CHARACTERSET, don't convert it.
It is more likely you'll never use it and AL16UTF16 contains all what AL32UTF8 contains.
Use AL32UTF8 and not UTF8 that is no more supported from 10g.

Regards
Michel

Report message to a moderator

Re: UTF8 character set conversion [message #305435 is a reply to message #305408]

Mon, 10 March 2008 14:47

caprikar
Messages: 226
Registered: March 2007

Senior Member

Thanks

Report message to a moderator

Previous Topic:	Query - Evaluating Inteval parameter in DBMS_JOB
Next Topic:	probelm creating function-based-index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:08:45 CST 2024