Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
freim
Posts: 2
Joined: Mon 10 Aug 2020 11:52

Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by freim » Tue 21 Sep 2021 05:42

Database: Firebird 3
Default CharSet UTF8
Default Collation UNICODE_CI

IBCConnection.Options.UseUnicode := True

Trying to insert and post a new record fails: 'unable to allocate memory from operating system'
Any idea?

crosspost https://www.delphipraxis.net/208841-fir ... ost1495161

Thanks

Frank Reim

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

Re: Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by ViktorV » Tue 21 Sep 2021 10:37

Hi Frank,

Thank you for the info provided!
We have successfully reproduced the issue and at the moment our team is investigating it.
Please, rest assured that as soon as we have any results, we will immediately let you know.
Please, let us know if you have any additional questions or need any kind of additional instructions!

Best regards,
Viktor

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

Re: Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by ViktorV » Wed 17 Nov 2021 13:29

Dear Frank!

Kindly be informed that we have fixed the bug you mentioned and its fix will be included in the next build of UniDAC.
We can send you a nightly build that includes this change, so you can check if this change solves the problem on your side.

To do this, please provide us your license number and the version of the IDE you are using via our contact form:
https://devart.com/company/contactform.html

Robinho599
Posts: 2
Joined: Fri 06 May 2022 14:04

Re: Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by Robinho599 » Mon 09 May 2022 09:19

Hi,

unfortunately the problem still happens with the IBDAC components.
You just need to connect to a Firebird 3.0 database with Default Charset UTF8 and set "useUnicode = true".
Executing "select cast ( 'error' as varchar(6144)) from rdb$database" there occurs an error.
Executing "select cast ( 'error' as varchar(6143)) from rdb$database" there occurs no error.
If UseUnicode is deactivated, the SQL can be executed, but then there are incorrectly displayed chars like "ä", "ü" or "ö".

Unfortunately, the problem is very urgent for us, please have a look at it asap!

Best regards
Robin

Robinho599
Posts: 2
Joined: Fri 06 May 2022 14:04

Re: Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by Robinho599 » Wed 11 May 2022 12:33

Hi,

please have a look at the problem asap as it's a very urgent bug for our application.
There's no way I'm able to create a release with this bug.

Thanks in Advance.

Best regards
Robin

pavelpd
Devart Team
Posts: 47
Joined: Thu 06 Jan 2022 14:16

Re: Firebird 3 DB CharSet UTF8 UseUnicode does' nt work

Post by pavelpd » Mon 16 May 2022 14:24

Hi,
We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly IBDAC build including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html

Post Reply