Migrating DBExpress to Firedac

[Moreno 0]

Hello, 

our Company is migrating from DBExpress to FireDAC but we found a strange behavior.

 

In DBExpress we put in DBXConnections Characterset=UTF8 and everything was fine, now in FireDAC we did the same but the result of our query seems to ignore the characterset.

 

If we manually decode the results are ok, but it feel strange.

 

Are we missing something?

 

 

[Uwe Raabe 2057]

I cannot see the part where FDQuery actually makes use of the pooled connection montetest.

[Moreno 0]

 

I can provide a test application and database (firebird 2.5) if it can be usefull

[Uwe Raabe 2057]

Having a concrete test is always useful.

[Moreno 0]

I've prepared the test application with the sample database.

It should be ready to use, the database is in the exe application with fbclient.dll

 

https://drive.google.com/file/d/1qeKBiqdX9C4NVBdGpPZhcjUOF3aUV6aK/view?usp=sharing

 

Thank you for your help and support!

[Guest]

I thought (i still think) that a DAC connection "charset" property is for creating a DB. When you open a DB, the (firebird) charset is read. If FireDAC is correct, the dfm setting when opening the DB should be overwritten with the DBs charset. HTH.

[Moreno 0]

If we change the charset of the fields on the database the values are displayed well with FireDAC and DBX.

 

We tried to change characterset on FireDAC and nothing changed, probably it's just as you said, the charset is read from the database. 

[Guest]

if Firebird you can use "charset xxxx  collation zzzz " on:

• Create;
• Column use (select, update, insert, order by, where... etc...) if necessary (it can be distinct of "create db/tables" definition"

more http://www.destructor.de/firebird/charsets.htm

Edited February 22, 2022 by Guest

[Serge_G 87]

Hi,

Suggestion : in the archive, don't put GDB file but a backup (fbk) of the database

Unfortunately, I have no Firebird 4 installed (well running to be clear)  to check 

[Guest]

MSWindows +10 had conflict with "GDB" file extension with Firebird

[Serge_G 87]

Yes but easy to override. GDB for MSWindows is sort of backup if in "MS folders". 
But, aware of that I effectively use fdb or fb extension for my databases