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

On Tue, 01 Mar 2011 23:49:45 -0800, Shahabeddin Hosseinkhah wrote:

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



--
http://mgogala.byethost5.com

On Mar 2, 7:49*am, Shahabeddin Hosseinkhah <hosseink... (AT) gmail (DOT) com>
wrote:
As Mladen says, check the NLS settings on your client.

HTH

-g

On Mar 1, 11:49*pm, Shahabeddin Hosseinkhah <hosseink... (AT) gmail (DOT) com>
wrote:
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.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2011/mar/01/fox/

On 2011-03-02 08:49, Shahabeddin Hosseinkhah 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

On Thu, 24 Mar 2011 21:07:34 +0100, Svend Jensen wrote:

<duck>
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.
</duck>

04/01 is close enough to send a post like this.



--
http://mgogala.byethost5.com

Preston wrote,on my timestamp of 25/03/2011 8:09 PM:

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

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


Hmmm, it looks like NLS will not fade away any time soon.



--
http://mgogala.byethost5.com

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.

Just get over it ...

On 25 mrt, 10:09, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote:
Except the period just before April Fool's, Mladens abuse of the
English language is quite innocuous...

--
Jeroen