Oracle CLOB and UTF8
Original Reporter info from Mantis: menounsef
-
Reporter name: Dave Connolly
Original Reporter info from Mantis: menounsef
- Reporter name: Dave Connolly
Description:
Using TOracleConnection to retrieve an Oracle CLOB column containing "abcdefgáéíóúøå" results in corrupted data.
The same data in a VARCHAR2 or NVARCHAR2 column is correct.
Problem is located in TOracleConnection.LoadBlobIntoBuffer
Steps to reproduce:
Create an Oracle table with a CLOB column.
Populate CLOB column with "abcdefgáéíóúøå"
Write program using TOracleConnection to select and display this data.