Home » RDBMS Server » Server Administration » unicode characterset (10.2.0.2)
unicode characterset [message #395589] Wed, 01 April 2009 23:42 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I have one basic question:-
Does WE8ISO8859P1 support unicode characterset?
Regards,
Varun Punj,
Re: unicode characterset [message #395591 is a reply to message #395589] Wed, 01 April 2009 23:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Does WE8ISO8859P1 support unicode characterset?
as in UTF-8? then no.
Re: unicode characterset [message #395596 is a reply to message #395591] Thu, 02 April 2009 00:04 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks blackwan for the reply.Can you please tell me:-
If database has AL16UTF16 as national characterset and
WE8ISO8859P1 as database characterset.Will it support
unicode in this scenario.
Regards,
Varun Punj,
Re: unicode characterset [message #395613 is a reply to message #395596] Thu, 02 April 2009 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which scenario? Do you know the meaning of national character set and its use?

Regards
Michel
Re: unicode characterset [message #395787 is a reply to message #395613] Thu, 02 April 2009 10:23 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Michel,
A national character set is an alternate character set that
enables you to store Unicode character data in a database that
does not have a Unicode database character set.
So even if database characterset is WE8ISO8859P1,still it
can support unicode if the national characterset is AL16UTF16
but datatypes used should be nchar,nvarchar instead
of char,varchar.
Please confirm if it is right.
Regards,
Varun Punj,
Re: unicode characterset [message #395797 is a reply to message #395787] Thu, 02 April 2009 10:41 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Right but who use 'N'datatypes?

Regards
Michel
Previous Topic: listener.trc file is compressable or not ?
Next Topic: monitoring tool
Goto Forum:
  


Current Time: Sun Dec 01 20:26:48 CST 2024