Re: How to convert data with different charsets into other databases?
From: joel garry <joel-garry_at_home.com>
Date: Wed, 2 Mar 2011 09:17:17 -0800 (PST)
Message-ID: <d07bb83a-66c8-461e-9eb2-cc09f05f4119_at_y31g2000prd.googlegroups.com>
On Mar 1, 11:49 pm, 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:17:17 -0800 (PST)
Message-ID: <d07bb83a-66c8-461e-9eb2-cc09f05f4119_at_y31g2000prd.googlegroups.com>
On Mar 1, 11:49 pm, 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
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-characters-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
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2011/mar/01/fox/Received on Wed Mar 02 2011 - 11:17:17 CST