[fpc-devel] Oracle CLOB and UTF8

[Michael Van Canneyt]

On Wed, 6 Sep 2017, Dave Connolly wrote:

> Hi all,
>
> I've got a database with a CLOB column containing "abcdefgáéíóúøå"
>
> I'm using the TOracleConnection to select this data and it comes back
> corrupted "abcdefgáéí???"
>
> This only happens when using a CLOB. If I put the same data in a VARCHAR2
> or NVARCHAR2 the results are correct.
>
> The OCILobGetLength in the procedure TOracleConnection.LoadBlobIntoBuffer
> returns 14. This is the number of characters in the string, but it is not
> taking the double-byte characters into account. The length in the case
> should be 21.
>
> Is this a known issue?

No, it is not. Please report it in the bugtracker.

Michael.