Hi, all! I am having an issue between Oracle 8i and 9i databases. We have always used varchar2 in Oracle 8i. Now, in 9i, a vendor has updated the database and changed all varchar2 fields to nvarchar2. Well, the 8i database uses that data and I can't seem to get the nvarchar2 to convert to varchar2. I have a stored procedure which gets data from the 9i db and puts it into the 8i db. However, I keep getting an error of "PLS_00560: chararcter set mismatch." We have tried a few things, ie wrapping the NVC2 data in a TO_CHAR function which didn't work. We have also tried TRANSLATE(USING CHAR_CS), which did work, but stored extra stuff in the 8i database. It prints out in SQLPlus like ' 3 P P ', but there aren't spaces. When I looked at the data in the 8i db table, it had boxes (looks to me like hard returns!) in between the actual numbers. I don't know what those are or how to get rid of them. Any ideas would be appreciated!
Thanks.
Susan
Start Free Trial
