Does Oracle 10g automatically escape double quotes in recordsets?

Question

I am encountering an interesting issue with an application that was migrated from Oracle 9i to 10g.
Previously, we had a problem when a field contained double quotes since Oracle recordsets encapsulated fields in double quotes.

Example: "field1"||"field2"||"field "Y" 3"||"field4"

Since the move to 10g, I believe that the Oracle client-side driver is parsing the double quotes and replacing them with "

Unfortunately I don't have an old 9i environment to test my theory.

Have you seen similar behavior or can someone validate if my theory is true?

Answer 1

It's an estrange behavior. Can you check your NLS_xx environment variables? Some NLS_xx variables can translate chars, for instance NLS_LANG can translate acutes from a latin charset on client to a us2ascii charset on server.

To be sure about what is going, try to trace Net connections. You'll see everything moving from a side to other. Be careful...