OraFAQ Forum: Windows » convert the database character set?

Home » Infrastructure » Windows » convert the database character set? (oracle10g release2)

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

convert the database character set? [message #456503]

Tue, 18 May 2010 03:31

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

Report message to a moderator

Re: convert the database character set? [message #456508 is a reply to message #456503]

Tue, 18 May 2010 03:35

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

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

Report message to a moderator

Re: convert the database character set? [message #456512 is a reply to message #456508]

Tue, 18 May 2010 03:43

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

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

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

Report message to a moderator

Re: convert the database character set? [message #456518 is a reply to message #456513]

Tue, 18 May 2010 04:03

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