Home » RDBMS Server » Server Administration » characterset UTF8 and WE8MSWIN1252 (oracle 10g R2)
characterset UTF8 and WE8MSWIN1252 [message #287039] Tue, 11 December 2007 00:06 Go to next message
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

Re: characterset UTF8 and WE8MSWIN1252 [message #287045 is a reply to message #287039] Tue, 11 December 2007 00:21 Go to previous messageGo to next message
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?
Re: characterset UTF8 and WE8MSWIN1252 [message #287067 is a reply to message #287039] Tue, 11 December 2007 00:56 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Reinstallation of ORACLE
Next Topic: : ORA-00603: ORACLE server session terminated by fatal error
Goto Forum:
  


Current Time: Sat Dec 03 01:02:57 CST 2016

Total time taken to generate the page: 0.28002 seconds