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:

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



-- 
http://mgogala.byethost5.com

On Mar 2, 7:49=A0am, Shahabeddin Hosseinkhah <hosseink...@gmail.com>
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

On Mar 1, 11:49=A0pm, Shahabeddin Hosseinkhah <hosseink...@gmail.com>
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/04/special-char=
acters-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:
> 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

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

<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

Mladen Gogala wrote:

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

What's the 4th January got to do with your abhorrent abuse of the
English language..?

-- 
Preston.

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

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

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.

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



-- 
http://mgogala.byethost5.com

Noons:

# Everything! =A0It'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...@nowhere.invalid> wrote:
> Mladen Gogala wrote:
> > 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. =A0To avoid this create your databases with a larger charset
> > > as utf8 or al32utf16, or whatever is fitting Your needs.
>
> > > /Svend
>
> > <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. =A0When 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.
>
> What's the 4th January got to do with your abhorrent abuse of the
> English language..?
>

Except the period just before April Fool's, Mladens abuse of the
English language is quite innocuous...

--
Jeroen

John Hurley <hurleyjohnb@yahoo.com> writes:

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

Not around here!

Still, push that line while you can and start preparing to modify it to 

But "american" is dead ... seriously it is Spanish ... has been for a
really long time.

Just get over it ...



-- 
tcross (at) rapttech dot com dot au

John Hurley wrote,on my timestamp of 26/03/2011 8:53 AM:

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

habla usted espa=F1ol?
;)

On 27 mar, 06:21, Noons <wizofo...@yahoo.com.au> wrote:
> John Hurley wrote,on my timestamp of 26/03/2011 8:53 AM:
>
> habla usted espa=F1ol?
> ;)

Yo s=ED, Nuno. Lo mismo que casi todos los hermanos portugueses. ;-)

Saludos.

Carlinhos.

On Mar 27, 9:25=A0am, CarlosAL <miotromailcar...@netscape.net> wrote:
> On 27 mar, 06:21, Noons <wizofo...@yahoo.com.au> wrote:
>
> > John Hurley wrote,on my timestamp of 26/03/2011 8:53 AM:
>
> > habla usted espa=F1ol?
> > ;)
>
> Yo s=ED, Nuno. Lo mismo que casi todos los hermanos portugueses. ;-)
>
> Saludos.
>
> Carlinhos.

Mmmmmm, Cheesy Pork.

jg
--
@home.com is bogus.
'Larry Ellison is a very polite man who refuses to allow people to use
four letter words beginning with "f" in his presence - like "free" for
example. '  http://www.zdnet.com/blog/crm/whither-oracle/2867

joel garry wrote,on my timestamp of 29/03/2011 3:35 AM:

>>
>>> habla usted espa=F1ol?
>>> ;)
>>
>> Yo s=ED, Nuno. Lo mismo que casi todos los hermanos portugueses. ;-)
>
> Mmmmmm, Cheesy Pork.

Hep, pajero!  Cuida-te: nosotros los patanegras te van a cuidar!
;)