Problems with Unicode CLOBs
Posted: Thu 29 Mar 2007 00:54
Hi,
I'm trying to use TOraLob objects to read and write Unicode CLOB data. When I write, I assign the AsWideString propery, say 'aaaaaa', which correctly sets the Size propery to 12 (the number of bytes). However when I read the same data and try to get the TOraLob.AsWideString, I get an OCI error, because it tries to read 0 bytes! Then I attempt to use the Read method with the Size of the CLOB as the number of bytes, and I get only half of my data. It appears that the Size property now returns the number of characters, not bytes (6 in the example)!
I'm using Oracle 10.2 and ODAC 5.55.
Thanks,
Roman
I'm trying to use TOraLob objects to read and write Unicode CLOB data. When I write, I assign the AsWideString propery, say 'aaaaaa', which correctly sets the Size propery to 12 (the number of bytes). However when I read the same data and try to get the TOraLob.AsWideString, I get an OCI error, because it tries to read 0 bytes! Then I attempt to use the Read method with the Size of the CLOB as the number of bytes, and I get only half of my data. It appears that the Size property now returns the number of characters, not bytes (6 in the example)!
I'm using Oracle 10.2 and ODAC 5.55.
Thanks,
Roman