Em 10/12/2017 11:08, Gabor Boros escreveu: > 2017. 12. 10. 12:29 keltezéssel, Adriano dos Santos Fernandes írta: >> How can you order by a blob? It's an error anyway. > > For example: > SELECT * FROM TABLE1 ORDER BY (CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD > FROM 1 FOR 40) AS VARCHAR(40))) >
Your description requires much more information for investigation. What is "change the ORDER BY ASC/DESC in a query and close/open it"? Is it same statement handle? What about WIN1250 with collation WIN1250? Does it fetch or pre-fetch data? If the problem can't be reproduces with a simple database and simple application, it's probably another problem. Adriano ------------------------------------------------------------------------------ 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
