12.12.2017 19:55, Gabor Boros wrote:
2017. 12. 12. 18:31 keltezéssel, Vlad Khorsun via Firebird-devel írta:
12.12.2017 17:38, Gabor Boros wrote:
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple application and three databases. Can I send to you privately? I attached earlier but got a message about the 40
KB body limit.
You may send it to me. Or, better, send download link.
Already sent a link to your address with a short message. I hope will arrive.
I received it, thanks. I traced application and must agree with Adriano -
connection charset is UTF8 and, when it is not the same as blob charset, every
fetched blob is transliterated by the engine into connection charset. To do it,
engine creates temporary blob in connection's charset for every record in result
set. This temporary blobs could be released on commit (rollback) only, but your
application works in the single RCRO transaction.
Should note, ORDER BY doesn't matters here.
Regards,
Vlad
PS Note, statement below doesn't eat memory :
SELECT CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40))
FROM TABLE1
ORDER BY 1;
you may use it as workaround, if possible.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
