<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>as far as I remember I have problems (when I have implemented
support for CLOBs) you describe as well.</p>
<p>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) ...
I have never used Oracle DB except for one period when I have
fixed some errors found in our db test suite.<br>
</p>
There are some API functions like OCILobCharSetId(), which probably
can be used to guess "character length" based on known character set
ids.<br>
<br>
If you are aware of working solution, please submit bug report and
attach patch ...<br>
Thanks<br>
-Laco.<br>
<br>
<br>
<blockquote type="cite"
cite="mid:CAM_T2NS8kTvHEKxY8OQfxjGa9onmSs+Cnj=ZkZ1emVn88j8ONA@mail.gmail.com">
<div dir="ltr">
<div>Hi all, <br>
</div>
<div><br>
</div>
<div>I've got a database with a CLOB column containing
"abcdefgáéíóúøå"</div>
<div><br>
</div>
<div>I'm using the TOracleConnection to select this data and it
comes back corrupted "abcdefgáéí�"</div>
<div><br>
</div>
<div>This only happens when using a CLOB. If I put the same data
in a VARCHAR2 or NVARCHAR2 the results are correct.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Is this a known issue?</div>
<div><br>
</div>
<div>Many thanks,</div>
<div>Dave<br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
fpc-devel maillist - <a class="moz-txt-link-abbreviated" href="mailto:fpc-devel@lists.freepascal.org">fpc-devel@lists.freepascal.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel">http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel</a>
</pre>
</blockquote>
<br>
</body>
</html>