Please advise, suddenly have nul characters in a blob (firebird 2.5)
-
- Posts: 4
- Joined: Mon 14 Jun 2021 20:26
Please advise, suddenly have nul characters in a blob (firebird 2.5)
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?
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)
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
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
-
- Posts: 4
- Joined: Mon 14 Jun 2021 20:26
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
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.
-
- Posts: 4
- Joined: Mon 14 Jun 2021 20:26
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
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
So maybe i should use 8.2.4
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
Hi,
we use UniDAC 8.3.2 with actual Sydney 10.4 Update 2 and PostgreSQL with no problems with memos and blobs.
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)
Hi Frank,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
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)
Hey Delphiwizard,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?
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)
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
-
- Posts: 4
- Joined: Mon 14 Jun 2021 20:26
Re: Please advise, suddenly have nul characters in a blob (firebird 2.5)
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.
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)
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.
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.