Re: character set conversion error

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 19 Jul 2007 09:58:55 +0200
Message-ID: <f7n5jn$ld3$1@news5.zwoll1.ov.home.nl>

-----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 Thu Jul 19 2007 - 02:58:55 CDT