Re: character set conversion error

From: Mohd Al Zarooni <dawraat_at_gmail.com>
Date: Sat, 21 Jul 2007 13:03:50 +0400
Message-ID: <f7si61$aqu102@news-dxb.emirates.net.ae>

Database X Oracle version 8.1.7.4 Charchater set AR8ISO8859P6 Database Y Oracle cersion 10.2.0.2 Charchater set AL32UTF8

Both X & Y running on SUN Solaris Platform.

Thanks.

Frank van Bortel wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Mohd Al Zarooni wrote:
>

>>Hi,
>>
>>I need to let Database X which has charset AR8ISO8859P6 to retrieve data
>>over dblink from database Y which has charset UT8.
>>
>>I am getting the following error.
>>
>>ERROR at line 1:
>>ORA-02068: following severe error from B.oracle
>>ORA-24365: error in character conversion
>>
>>any idea or work around to solve the problem without changing the
>>character set of database X.
>>
>>Thanks.
>>

>
> Versions?!? UTF8 implementations have changed dramatically from 8i
> on - you may just run into one of these situations...
>
> You could change the character set of the "client" - in quotes
> on purpose, as one server acts as client to the other.
> It's a matter of environment variables - platforms?!?
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGnxm/Lw8L4IAs830RArwGAJ9szZXNNg2SYH3T0lXGvuFzg9BDnACfbfbO
> 4ElpDOoUCVj3sqeHor68UsM=
> =Zj5O
> -----END PGP SIGNATURE-----
Received on Sat Jul 21 2007 - 04:03:50 CDT