Home » RDBMS Server » Server Utilities » national language characterset
national language characterset [message #289029] Wed, 19 December 2007 05:26 Go to next message
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 #289046 is a reply to message #289029] Wed, 19 December 2007 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Q1. It means that source and target (N)character code points may not be the same (and in this case they are not)

Q2. Don't understand the question. You can see national language character set in NLS_DATABASE_PARAMETERS view.

Regards
Michel
Re: national language characterset [message #289160 is a reply to message #289046] Wed, 19 December 2007 22:22 Go to previous messageGo to next message
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 #289168 is a reply to message #289160] Wed, 19 December 2007 23:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I don't understand "make out".

Quote:

Isnt this information required for the creation of user

No this is a DATABASE parameter.

Quote:

choosing the right characterset settings so that after the import the data is intact?

You can't choose the character set in the final database, it is fixed.

Regards
Michel
Re: national language characterset [message #289177 is a reply to message #289168] Wed, 19 December 2007 23:51 Go to previous messageGo to next message
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
Michel Cadot
Messages: 68625
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

Previous Topic: EXP Error
Next Topic: Removing TABLE_STATISTICS from data pump
Goto Forum:
  


Current Time: Thu Mar 28 15:28:09 CDT 2024