It's highly unlikely that the CMP engine is doing this, otherwise I'm sure there would be a LOT more complaints.
It may possibly be your JDBC driver - make sure it is current.
Alternatively, there is something strange with your data mappings (java type <-> SQL column) that is causing some kind of data conversion to happen.
I suspect that the JDBC driver is messing up the USASCII <-> Unicode translation of strings.
Thanks Steve. Afterwards, I did realize that pure JDBC had the same issue. We use Ashna drivers. Can you recommend a popular/stable free JDBC driver?
Sorry, I don't use this product.
I suggest a google search, or possibly ask this specific question in the forum under a new topic, such as "JDBC driver recommendations for SQL Server 7?"