migration from WE8ISO8859P1 to AR8MSWIN1256

From: shady kazan <shadykazan_at_gmail.com>
Date: Sun, 23 Nov 2008 08:40:36 -0800 (PST)
Message-ID: <0b17f29f-e888-4fd6-9718-32b1aaae2090@r40g2000yqj.googlegroups.com>

I have a 9i database with WE8ISO8859P1 characterset, the database is supposed to hold Farsi characters (weird!!), so my client developers have coded a PLSQL
function that converts any characters read from this database into a character from a non standard charset they had come up with.And they are using this function to read from the database by a client and it seems to be working because the data read from the database seems to be shown in the right format.
It seems that this "non standard characterset" is nothing but the AR8MSWIN1256 charset.
So knowing that, and knowing that AR8MSWIN1256 is not a superset of WE8ISO8859P1, would creating a database link from the AR8 DB(10g) to the WE8 DB(9i) and ship data through it converting it using that function work?

it seems to me that any migration solution will have to use this function to work.

thank you Received on Sun Nov 23 2008 - 10:40:36 CST

Original text of this message