Blob fields problem with Unicode Firebird
Posted: Wed 04 Sep 2019 09:45
I am using:
Firebird 2.5.8
Delphi 10.3.2
Unidac 8.0.1
Windows 10, but also WIndows 7
I connect to the database using SpecificOptions.UseUnicode set to True, Charset UTF8.
If I try to set values containing Ukrainian characters to VARCHAR field, it works ok.
But if I set value like 'стан добрий' to blob field (BLOB SUB_TYPE TEXT), charset UTF8, it is changed to characters like '????'
I do not know if it is connected to Delphi or Unidac version, but it was working ok for many years before upgrading my tools.
Am I doing something wrong? Maybe I missed some configuration in new Delphi compiler? Did something changed?
How to resolve it?
Firebird 2.5.8
Delphi 10.3.2
Unidac 8.0.1
Windows 10, but also WIndows 7
I connect to the database using SpecificOptions.UseUnicode set to True, Charset UTF8.
If I try to set values containing Ukrainian characters to VARCHAR field, it works ok.
But if I set value like 'стан добрий' to blob field (BLOB SUB_TYPE TEXT), charset UTF8, it is changed to characters like '????'
I do not know if it is connected to Delphi or Unidac version, but it was working ok for many years before upgrading my tools.
Am I doing something wrong? Maybe I missed some configuration in new Delphi compiler? Did something changed?
How to resolve it?