Please advise, suddenly have nul characters in a blob (firebird 2.5)

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Delphiwizard
Posts: 4
Joined: Mon 14 Jun 2021 20:26

Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Delphiwizard » Mon 14 Jun 2021 20:40

I had several reports from customers where the test in blobs in a firebird database are suddenly changed with many null characters like here

this text for example 'ivm machtiging verkoop onroerend goed uit de hand '#$D#$A
Is now changed to
'i'#0'v'#0'm'#0' '#0'm'#0'a'#0'c'#0'h'#0't'#0'i'#0'g'#0'i'#0'n'#0'g'#0' '#0'v'#0'e'#0'r'#0'k'#0'o'#0'o'#0'p'#0' '#0'o'#0'n'#0'r'#0'o'#0'e'#0'r'#0'e'#0'n'#0'd'#0' '#0'g'#0'o'#0'e'#0'd'#0' '#0'u'#0'i'#0't'#0' '#0'd'#0'e'#0' '#0'h'#0'a'#0'n'#0'd'#0' '#0#$D#0#$A#0

I haven't found yet when, where or how the text changes, right after insert the text still seems fine.
Newer Unidac, upgrade from Delphi Tokyo to Sydney latest patch installed,
It could be a devexpress bug, or a unidac or delphi change, i really have no idea on this one, maybe someone has an idea?

Frank2021
Posts: 4
Joined: Mon 03 May 2021 10:37

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Frank2021 » Tue 15 Jun 2021 06:00

Hi,

look this posts:

Unidac 8.4.3 and MemoField
by DanielNTM » Mon 10 May 2021 10:32
viewtopic.php?f=28&t=45497

or

Error using UniDac and Postgresql

by Ole Ekerhovd » Thu 08 Apr 2021 11:00
viewtopic.php?f=28&t=44849

We still wait for a fix.

The version 8.4.* is useable! We still use 8.3.2.

Not a good promotion for devart.

Good luck for you an your customers DelphiWizard!

Regards
Frank

Delphiwizard
Posts: 4
Joined: Mon 14 Jun 2021 20:26

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Delphiwizard » Tue 15 Jun 2021 06:42

Interesting Frank, but my current version is Unidac 8.3.2 for RAD Studio 10.4, so i have to use a even lower version?Please advise which version i have to install that doesn't have this problem.

Delphiwizard
Posts: 4
Joined: Mon 14 Jun 2021 20:26

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Delphiwizard » Tue 15 Jun 2021 06:51

8.2.4 is the lowest version that has a build for sydney so i guess i could use that, on Tokyo we still used 7.3.9.
So maybe i should use 8.2.4

Frank2021
Posts: 4
Joined: Mon 03 May 2021 10:37

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Frank2021 » Wed 16 Jun 2021 07:31

Hi,

we use UniDAC 8.3.2 with actual Sydney 10.4 Update 2 and PostgreSQL with no problems with memos and blobs.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by ViktorV » Fri 18 Jun 2021 10:48

Frank2021 wrote: Tue 15 Jun 2021 06:00 Hi,

look this posts:

Unidac 8.4.3 and MemoField
by DanielNTM » Mon 10 May 2021 10:32
viewtopic.php?f=28&t=45497

or

Error using UniDac and Postgresql

by Ole Ekerhovd » Thu 08 Apr 2021 11:00
viewtopic.php?f=28&t=44849

We still wait for a fix.

The version 8.4.* is useable! We still use 8.3.2.

Not a good promotion for devart.

Good luck for you an your customers DelphiWizard!

Regards
Frank
Hi Frank,

Just a small update on this request viewtopic.php?f=28&t=45497 we have already fixed this issue.

Regards,
Viktor

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by ViktorV » Fri 18 Jun 2021 10:50

Delphiwizard wrote: Mon 14 Jun 2021 20:40 I had several reports from customers where the test in blobs in a firebird database are suddenly changed with many null characters like here

this text for example 'ivm machtiging verkoop onroerend goed uit de hand '#$D#$A
Is now changed to
'i'#0'v'#0'm'#0' '#0'm'#0'a'#0'c'#0'h'#0't'#0'i'#0'g'#0'i'#0'n'#0'g'#0' '#0'v'#0'e'#0'r'#0'k'#0'o'#0'o'#0'p'#0' '#0'o'#0'n'#0'r'#0'o'#0'e'#0'r'#0'e'#0'n'#0'd'#0' '#0'g'#0'o'#0'e'#0'd'#0' '#0'u'#0'i'#0't'#0' '#0'd'#0'e'#0' '#0'h'#0'a'#0'n'#0'd'#0' '#0#$D#0#$A#0

I haven't found yet when, where or how the text changes, right after insert the text still seems fine.
Newer Unidac, upgrade from Delphi Tokyo to Sydney latest patch installed,
It could be a devexpress bug, or a unidac or delphi change, i really have no idea on this one, maybe someone has an idea?
Hey Delphiwizard,

Looks like the fix for the issue which was described above is related your request.
I can create a nightly build for you so you could check if everything works fine. Just send me your license number and IDE version using our contact form so I could proceed with this request:
https://www.devart.com/company/contactform.html
If the issue will still persist in a new build as well, please send us the sample in reply to our email.

Regards,
Viktor

evgeniym
Devart Team
Posts: 103
Joined: Thu 13 May 2021 07:08

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by evgeniym » Fri 18 Jun 2021 13:38

Frank2021 wrote: Tue 15 Jun 2021 06:00 Hi,

look this posts:

Unidac 8.4.3 and MemoField
by DanielNTM » Mon 10 May 2021 10:32
viewtopic.php?f=28&t=45497

or

Error using UniDac and Postgresql

by Ole Ekerhovd » Thu 08 Apr 2021 11:00
viewtopic.php?f=28&t=44849

We still wait for a fix.

The version 8.4.* is useable! We still use 8.3.2.

Not a good promotion for devart.

Good luck for you an your customers DelphiWizard!

Regards
Frank

Hi Frank,
Regarding topic viewtopic.php?f=28&t=44849 we still did not receive the sample.

We could not reproduce the issue using provided data. Please send us small sample which demonstrates described behavior along with DDL scripts to create and fill-in test database objects.
You can send them to us using our contact form:
https://devart.com/company/contactform.html

Regards,
Evgeniy

Delphiwizard
Posts: 4
Joined: Mon 14 Jun 2021 20:26

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by Delphiwizard » Fri 19 Nov 2021 07:42

FYI i finally got a build of our software out, using the beta build of Unidac Victor supplied to me and the problem still persists.
Making a demo/test application for now is impossible as i don't know how the #0 characters get in the blob in the first place.

I am now going to make a trigger in the firebird database so i can track the changes to all records with before and after text of the blob, and which user + application made the changes so i have a idea where to start looking.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)

Post by ViktorV » Thu 25 Nov 2021 13:10

Kindly note that as far as we can see you have an outdated version of UniDAC software and at the moment, we have the newest version available.

Can you please try updating your product using the link below:
https://www.devart.com/unidac/download.html
Once the new version is installed, please check and let us know if the issue still persists.

Please be informed that in case the issue persists still the only possible way to resolve it is to reproduce it in our environment first.

Post Reply