How to convert data with different charsets into other databases?

hi
we want to use database link to connect a Database for operating the
select,update or ... commands,our destination database is WE8ISO8859P1
and current database is AR8MSWIN1256 cahrset, but when we operate a
command to view data,all NonEnglish characters appear odd wich we can
not recognize the appeared text, also if we use convert function no
change would make, please help us to view right charachters with our
database link.
thanks

Re: How to convert data with different charsets into otherdatabases?

On Tue, 01 Mar 2011 23:49:45 -0800, Shahabeddin Hosseinkhah wrote:
> hi
> we want to use database link to connect a Database for operating the
> select,update or ... commands,our destination database is WE8ISO8859P1
> and current database is AR8MSWIN1256 cahrset, but when we operate a
> command to view data,all NonEnglish characters appear odd wich we can
> not recognize the appeared text, also if we use convert function no
> change would make, please help us to view right charachters with our
> database link.
> thanks

I am not sure what seems to be the problem Oracle*Net does the conversion
automatically. This may be a problem with your client.

Re: How to convert data with different charsets into other databases?

On Mar 2, 7:49*am, Shahabeddin Hosseinkhah
wrote:
> hi
> we want to use database link to connect a Database for operating the
> select,update or ... commands,our destination database is WE8ISO8859P1
> and current database is AR8MSWIN1256 cahrset, but when we operate a
> command to view data,all NonEnglish characters appear odd wich we can
> not recognize the appeared text, also if we use convert function no
> change would make, please help us to view right charachters with our
> database link.
> thanks

As Mladen says, check the NLS settings on your client.

HTH

-g

Re: How to convert data with different charsets into other databases?

On Mar 1, 11:49*pm, Shahabeddin Hosseinkhah
wrote:
> hi
> we want to use database link to connect a Database for operating the
> select,update or ... commands,our destination database is WE8ISO8859P1
> and current database is AR8MSWIN1256 cahrset, but when we operate a
> command to view data,all NonEnglish characters appear odd wich we can
> not recognize the appeared text, also if we use convert function no
> change would make, please help us to view right charachters with our
> database link.
> thanks

The problem could simply be in how you are viewing it, perhaps the
code set on your PC. MOS has a number of documents explaining NLS
issues, the docs have the globalization guide, and Frank has an
informative blog series: http://vanbortel.blogspot.com/2009/0...rs-part-i.html

You can use the select dump(yourdata) from yourtable in sqlplus to be
sure the values are the same from each side of the link.

Re: How to convert data with different charsets into other databases?

On 2011-03-02 08:49, Shahabeddin Hosseinkhah wrote:
> hi
> we want to use database link to connect a Database for operating the
> select,update or ... commands,our destination database is WE8ISO8859P1
> and current database is AR8MSWIN1256 cahrset, but when we operate a
> command to view data,all NonEnglish characters appear odd wich we can
> not recognize the appeared text, also if we use convert function no
> change would make, please help us to view right charachters with our
> database link.
> thanks

As mswin1256 is a "richer" (more characters & signs defined) than
we8iso8859p1, You will loose stuff when saving in the "narrow" charset.
To avoid this create your databases with a larger charset as utf8 or
al32utf16, or whatever is fitting Your needs.

/Svend

Re: How to convert data with different charsets into otherdatabases?

On Thu, 24 Mar 2011 21:07:34 +0100, Svend Jensen wrote:
> As mswin1256 is a "richer" (more characters & signs defined) than
> we8iso8859p1, You will loose stuff when saving in the "narrow" charset.
> To avoid this create your databases with a larger charset as utf8 or
> al32utf16, or whatever is fitting Your needs.
>
> /Svend

I don't understand why would anyone need anything but US7ASCII? The
database world would be so much simpler, if only everyone spoke English.
When I say "English", I don't mean the exotic versions with the wrong
spelling, like "doughnut", "colour", "humour" etc.

Re: How to convert data with different charsets into otherdatabases?

Preston wrote,on my timestamp of 25/03/2011 8:09 PM:
>>
>>
>> I don't understand why would anyone need anything but US7ASCII? The
>> database world would be so much simpler, if only everyone spoke
>> English. When I say "English", I don't mean the exotic versions with
>> the wrong spelling, like "doughnut", "colour", "humour" etc.
>>
>>
>> 04/01 is close enough to send a post like this.
>
> What's the 4th January got to do with your abhorrent abuse of the
> English language..?
>

Everything! It's the Murrican (speaking of abhorrent abuse of the Queen's
language!) way of saying April Fool's.

Re: How to convert data with different charsets intootherdatabases?

On Fri, 25 Mar 2011 22:16:02 +1100, Noons wrote:

> Everything! It's the Murrican (speaking of abhorrent abuse of the
> Queen's language!) way of saying April Fool's.

Re: How to convert data with different charsets into otherdatabases?

Noons:

# Everything! *It's the Murrican (speaking of abhorrent abuse of the
Queen's language!) way of saying April Fool's.

Dude the english are a group of people ruled ( historically speaking
anyway ) by a bizarre set of individuals who brutally treated as much
of the world as they could hold onto to a series of pretty much
unspeakable levels of despotism/slaughter/colonialism.

Not convinced exactly that the current US politicians ( as much as I
worked to elect the current president ) are much better. Harsh
realities and strategic interests in natural resources make the next
50 years look pretty ugly.

But "english" is dead ... seriously it is American ... has been for a
really long time.