Using Unicode with Firebird 2.11 and Delphi 2009

Roaster2 · Post by **Roaster2** » Wed 18 Feb 2009 20:18

Hi,

what are the recommended settings in IbDac to use Unicode in an application (compiled with D2009) with Firebird 2.11?

I've already created a new FB database with character set UTF8 and used Collation UTF8 where appropriate.

Would that be the correct way to store Unicode data inside a FB database and what settings have to be used in IbDac to get fully Unicode support in the application?

Thanks,
Michael

Plash · Post by **Plash** » Thu 19 Feb 2009 09:17

You need to set the UseUnicode option of TIBCConnection to True for full Unicode support. If you store UTF8 data in BLOBs with subtype 1, set also EnableMemos option to True. This enables Unicode support for such BLOBs.