Double Characters recived when using Direct mode
Posted: Tue 24 Jan 2006 16:50
After setting mode to direct, data retrieved from oracle 9i contains double characters.
So for each single character we receive two bytes from the DB. The same thing doesn't happen if we connect through OCI mode.
Please guide on possible solution.
Earlier we thought that this is happening due to unicode set to true. but after setting unicode to false, we get the same thing.
Actually the 20 Hexcode gets prepend to each character, so for "TEST"
we receive data as "T E S T" with space containing 20 in hexa.
So for each single character we receive two bytes from the DB. The same thing doesn't happen if we connect through OCI mode.
Please guide on possible solution.
Earlier we thought that this is happening due to unicode set to true. but after setting unicode to false, we get the same thing.
Actually the 20 Hexcode gets prepend to each character, so for "TEST"
we receive data as "T E S T" with space containing 20 in hexa.