My DA Version: 9.2.103.1311
Delphi 10.2 / Delphi XE7
Database Server: Firebird 2.5
Driver:FireDac
My case is I try load a Picture to a Blob field. The Moment I load it it can display correctly. After Post to server, and reopen the dataset. It report the invalid picture format.
Then I do a testing case on that with a simple table in Firebird , Only Str and Blob binary type.
I find that post data and applypudate to server without refresh the datatable. The Blob content is correct and I save the blob field to a file.
After Reopen the datatable, I save the blob field to a file again. The data file size is different.
Before refresh one is greater than the after refresh one.
I attached the test case and the sample file 20170727-180912(good).bin is good one and 20170727-180919(bad).bin is the bad one.
your binaries work as expected on English non-unicode locale.
what is your non-unicode locale? Chinese?
if you set non-unicode locale to English, will it solve this case?
we had report that blobs work incorrectly with Chinese non-unicode locale. it was already fixed as #78175.
fix will be present in next beta
By the way, where to check the reported problem as I search in the forum but cant find any hints.
I spend a day to find the problem finally confirm it is issue from DA.
As we need the chinese as non-unicode any temporary workaround on that?