Re: How to convert data with different charsets into other databases?
From: gazzag <gareth_at_jamms.org>
Date: Wed, 2 Mar 2011 09:12:50 -0800 (PST)
Message-ID: <b1c391c1-1315-49b8-955b-6ec18c07d701_at_d12g2000vbz.googlegroups.com>
On Mar 2, 7:49 am, Shahabeddin Hosseinkhah <hosseink..._at_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
Date: Wed, 2 Mar 2011 09:12:50 -0800 (PST)
Message-ID: <b1c391c1-1315-49b8-955b-6ec18c07d701_at_d12g2000vbz.googlegroups.com>
On Mar 2, 7:49 am, Shahabeddin Hosseinkhah <hosseink..._at_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 Received on Wed Mar 02 2011 - 11:12:50 CST