OraFAQ Forum: Server Utilities » national language characterset

Home » RDBMS Server » Server Utilities » national language characterset

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

national language characterset [message #289029]

Wed, 19 December 2007 05:26

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

Report message to a moderator

Re: national language characterset [message #289046 is a reply to message #289029]

Wed, 19 December 2007 06:06

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: national language characterset [message #289160 is a reply to message #289046]

Wed, 19 December 2007 22:22

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?

Report message to a moderator

Re: national language characterset [message #289168 is a reply to message #289160]

Wed, 19 December 2007 23:24

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: national language characterset [message #289177 is a reply to message #289168]

Wed, 19 December 2007 23:51

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?

Report message to a moderator

Re: national language characterset [message #289190 is a reply to message #289177]

Thu, 20 December 2007 01:01

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:02:07 CST 2024