Corrupted Blob Issue

Data Abstract
1

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.

The file I load to the blob field is yellow.jpg.

you can download the sample at beblow:
http://175.45.23.206:8888/download/sample/blobissue.rar

The sample project I put back into the old version DA 8.2.89.1153 in delphi XE7 all is working correctly.

Please advice

.

2

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

3

Yes it works after change the non-unicode.

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?

4

fix will be present in this week’s beta

5

ok Thanks, any place to check reported like “fixed as #78175” information?

7

we don’t have public bug tracker because issues may contain some private information

8

tyi: beta was released.
can you confirm, that it works for you?

9

I miss your message. yes it works