OraFAQ Forum: Server Administration » characterset UTF8 and WE8MSWIN1252

Home » RDBMS Server » Server Administration » characterset UTF8 and WE8MSWIN1252 (oracle 10g R2)

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

characterset UTF8 and WE8MSWIN1252 [message #287039]

Tue, 11 December 2007 00:06

shachipathak
Messages: 16
Registered: December 2007
Location: Bangalore

Junior Member

Dear Sir,
Q1.A.Can i transfer data from a machine with specfications

NLS CHARACTERSET NLS_NCHAR CHARACTERSET
1. WE8MSWIN1252 AL16UTF16

to a machine with specifications

2. NLS CHARACTERSET NLS_NCHAR CHARACTERSET
UTF8 UTF8 ?

B.If YES what changes i need to do to data?

Q2.NLS CHARACTERSET NLS_NCHAR CHARACTERSET
WE8MSWIN1252 AL16UTF16
is the default characterset of Oracle.
Where do we get the option to change it to
NLS CHARACTERSET NLS_NCHAR CHARACTERSET
UTF8 UTF8

or

NLS CHARACTERSET NLS_NCHAR CHARACTERSET
UTF8 AL16UTF16 ?

Q3.What is the difference of having NLS_NCHAR CHARACTERSET
as UTF8 or AL16UTF16 ?

Thanks
Shachi

Report message to a moderator

Re: characterset UTF8 and WE8MSWIN1252 [message #287045 is a reply to message #287039]

Tue, 11 December 2007 00:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

.Can i transfer data from a machine with specfications

NLS CHARACTERSET NLS_NCHAR CHARACTERSET
1. WE8MSWIN1252 AL16UTF16

to a machine with specifications

2. NLS CHARACTERSET NLS_NCHAR CHARACTERSET
UTF8 UTF8 ?

Yes, Run csscan and see lossy conversion , if no lossy conversion then you can use csalter.

Quote:

If YES what changes i need to do to data?

It's totally upto you, You can modify your table definition or you can update your row to avoid lossy conversion.

Quote:

What is the difference of having NLS_NCHAR CHARACTERSET
as UTF8 or AL16UTF16 ?

Have you searched in google or in forum?

Now about your format of posting. Why so much space?

Report message to a moderator

Re: characterset UTF8 and WE8MSWIN1252 [message #287067 is a reply to message #287039]

Tue, 11 December 2007 00:56

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Where do we get the option to change it to

It is defined at database creation time.
You can't change it to UTF8 (or better AL32UTF8, UTF8 is obsolete).

Regards
Michel

Report message to a moderator

Previous Topic:	Reinstallation of ORACLE
Next Topic:	: ORA-00603: ORACLE server session terminated by fatal error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:56:07 CDT 2024