Re: [fpc-devel] Oracle CLOB and UTF8

2017-09-06 Thread Dave Connolly
Raised as bug 0032377 On 6 September 2017 at 13:48, LacaK wrote: > Hi, > > as far as I remember I have problems (when I have implemented support for > CLOBs) you describe as well. > > I do not have access to Oracle DB anymore so I can not fix it, w

Re: [fpc-devel] Oracle CLOB and UTF8

2017-09-06 Thread LacaK
Hi, as far as I remember I have problems (when I have implemented support for CLOBs) you describe as well. I do not have access to Oracle DB anymore so I can not fix it, worse I am not aware of easy way how to get from OCI API information about byte length (and connection character set) ...

Re: [fpc-devel] Oracle CLOB and UTF8

2017-09-06 Thread 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 NV

[fpc-devel] Oracle CLOB and UTF8

2017-09-06 Thread Dave Connolly
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 OCILobGetL