national language characterset [message #289029] |
Wed, 19 December 2007 05:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shachipathak
Messages: 16 Registered: December 2007 Location: Bangalore
|
Junior Member |
|
|
Dear Sir,
I have received an export log file which starts like
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
Q1.What does "possible charset conversion" mean?
Q2.How do we make out what is the national language character set of the specified server of which the export is done?
Thanks
Shachi
|
|
|
|
Re: national language characterset [message #289160 is a reply to message #289046] |
Wed, 19 December 2007 22:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shachipathak
Messages: 16 Registered: December 2007 Location: Bangalore
|
Junior Member |
|
|
I meant how we make out the national characterset before the import of the dump.
Isnt this information required for the creation of user and choosing the right characterset settings so that after the import the data is intact?
|
|
|
|
Re: national language characterset [message #289177 is a reply to message #289168] |
Wed, 19 December 2007 23:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shachipathak
Messages: 16 Registered: December 2007 Location: Bangalore
|
Junior Member |
|
|
I have not created the database and i dont want character mismatch between the exported data user and the new user where i want to import the data.
For this i hope both the charactersets are required?
|
|
|
Re: national language characterset [message #289190 is a reply to message #289177] |
Thu, 20 December 2007 01:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Sorry I didn't see your export, I thought you were importing.
You have to set your NLS_CHARACTERSET (or NLS_LANG) and NLS_NCHAR_CHARACTERSET environment parameters to the same values as the database if you don't want any conversion.
Regards
Michel
[Updated on: Thu, 20 December 2007 01:03] Report message to a moderator
|
|
|