I have a Delphi XE program then connects to a Firebird (2.5.1) database.
Everyting is fine using ASCII characters (doing this since Delphi 6) . I use
IBX components to access the database. One of my customers asked me to let
him input Ucrainean (cyrilic) characters into the program. Trying to
copy&paste the "Податковий код" text into a TDBEdit gets me some "?????????"
characters.

First of all I googled for some information.

I found out that I have to :

1. modify my TIBDatabase params -> added lc_ctype=UTF8
2. modify my database, a nice utility named fbclone converted to UTF8

fbclone.exe -v -s 192.168.80.5:C:\DEVELOP\GESTOCW\GESTOC.FDB -su sysdba -sp
*** -t 192.168.80.5:c:\develop\gestocw\gestoc_utf.fdb -tu sysdba -tp *** -u
sysdba -p *** -c UTF8

now my database :

CREATE DATABASE 'C:\DEVELOP\GESTOCW\GESTOC.FDB'
USER 'SYSDBA' PASSWORD '***'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UTF8 COLLATION UTF8;


The problem surely is on my side, because in IBExpert I copy & paste the
text and I have a "Display data as unicode (F3)" button, that does magic
:-) :

it toggles between showing me : "Податковий код" or "Податковий
код" .

please help me implement this in TDBEdit and TDBGrid.




Thank you,

Tiberiu