Home » Infrastructure » Windows » convert the database character set? (oracle10g release2)
icon5.gif  convert the database character set? [message #456503] Tue, 18 May 2010 03:31 Go to next message
itx005
Messages: 5
Registered: May 2010
Junior Member
Hi all ,,
i have a problem and i hope someone can provides solution for it.
i have a database in the server which is in character set AR8iso88p59p6 i want to export these data with convert it to AR8MSWIN1256 .

if there are no solution using EXPORT then how can i convert the database character set?

the data are displayed as garbage in .NET environment with character set AR8iso88p59p6 But When i tried on another computer and test database with AR8MSWIN1256 it's work just fine....
Please anyone
Re: convert the database character set? [message #456508 is a reply to message #456503] Tue, 18 May 2010 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just NLS parameters that are correctly set or not.
As we don't know when it was correctly set and when it was not (and I bet you don't know either) we can't know what are the correct data and what are the wrong ones.

To be correct, the client should have its NLS parameter set to the character set it actually uses.

Regards
Michel
Re: convert the database character set? [message #456512 is a reply to message #456508] Tue, 18 May 2010 03:43 Go to previous messageGo to next message
itx005
Messages: 5
Registered: May 2010
Junior Member
Thanks for replaying...

actually i know that the database in the source is set to AR8ISO8859P6 and it's using Form6i interface .
we want to develop a new application in .NET Environment so when Exporting these data and use it in .NET the data appears as Garbage Confused because .NET reads data that are in AR8MSWIN1256 .

[Updated on: Tue, 18 May 2010 03:45]

Report message to a moderator

Re: convert the database character set? [message #456513 is a reply to message #456512] Tue, 18 May 2010 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If NLS parameters are correctly set you don't see in which character set the data are stored.
If your .Net application works with AR8MSWIN1256 character set, then set your NLS_LANG parameter accordingly, Oracle will do the conversion automatically during the transfer of the data from database to client.

Regards
Michel
Re: convert the database character set? [message #456518 is a reply to message #456513] Tue, 18 May 2010 04:03 Go to previous messageGo to next message
itx005
Messages: 5
Registered: May 2010
Junior Member
Michel Cadot wrote on Tue, 18 May 2010 03:46
Oracle will do the conversion automatically during the transfer of the data from database to client.

i don't think that Oracle will do the conversion automatically i have checked the NLS_LANG parameter in my client which is AR8MSWIN1256 and in the server the NLS_LANG is AR8ISO8859P6

[Updated on: Tue, 18 May 2010 05:15] by Moderator

Report message to a moderator

Re: convert the database character set? [message #456525 is a reply to message #456518] Tue, 18 May 2010 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i don't think that Oracle will do the conversion automatically

And you are wrong.

Regards
Michel
Re: convert the database character set? [message #456527 is a reply to message #456525] Tue, 18 May 2010 05:37 Go to previous messageGo to next message
itx005
Messages: 5
Registered: May 2010
Junior Member
Ok then why whats the problem then?
Re: convert the database character set? [message #456537 is a reply to message #456527] Tue, 18 May 2010 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How can I know I have not your environment.
First check if data are correct regarding the database character set.

Regards
Michel
Re: convert the database character set? [message #456929 is a reply to message #456537] Thu, 20 May 2010 03:53 Go to previous messageGo to next message
itx005
Messages: 5
Registered: May 2010
Junior Member
when i change database character set to win1256 the data appears as garbage
Re: convert the database character set? [message #456936 is a reply to message #456929] Thu, 20 May 2010 05:10 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
First check if data are correct regarding the database character set.

For this you haev to dump the data, ALL the data.

You know the proverb: garbage in garbage out.

Regards
Michel

[Updated on: Thu, 20 May 2010 05:10]

Report message to a moderator

Previous Topic: database prob
Next Topic: Oracle 10g R1 installation problem on Windows7
Goto Forum:
  


Current Time: Fri Mar 29 10:11:02 CDT 2024