Page 1 of 1
Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Mon 14 Jun 2021 20:40
by Delphiwizard
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?
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Tue 15 Jun 2021 06:00
by Frank2021
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
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Tue 15 Jun 2021 06:42
by Delphiwizard
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.
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Tue 15 Jun 2021 06:51
by Delphiwizard
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
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Wed 16 Jun 2021 07:31
by Frank2021
Hi,
we use UniDAC 8.3.2 with actual Sydney 10.4 Update 2 and PostgreSQL with no problems with memos and blobs.
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Fri 18 Jun 2021 10:48
by ViktorV
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
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Fri 18 Jun 2021 10:50
by ViktorV
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
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Fri 18 Jun 2021 13:38
by evgeniym
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
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Fri 19 Nov 2021 07:42
by Delphiwizard
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.
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Posted: Thu 25 Nov 2021 13:10
by ViktorV
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.