One char in - different one out

I am running the same application against two different Oracle databases with the same schema. One database is set up with a 7 bit character set, the other an 8 bit. When I store a character string with a special character in it ( ASCII 133 ), and then retrieve that string, I get strange results.

With the database set up as a 7 bit character set, I get the character I stored (ASCII 133). With the database set up as an 8 bit character set, I get an ASCII 5. It seems as though I have lost the highest bit on the database set up as an 8 bit character set. Can anyone shed some light on this and provide a possible resolution?

Thanks. Received on Fri Feb 25 2000 - 13:19:55 CST