hi
this is a general question: can i use the zeos components in order to properly access and modify unicode-fields in my firebird database from delphi 7?
i'm not getting it done...
thanx,
martin
zeos and unicode
Moderators: gto, cipto_kh, EgonHugeist
You have to define use charset UNICODE_FSS when creating firebird database file.
Using following code (untested) should create the needed db file:
ZConnection.Properties.Add(
'CreateNewDatabase=CREATE DATABASE 'C:\firebirddb.FDB' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 4096 DEFAULT CHARACTER SET UNICODE_FSS');
ZConnection.Connect;
Then for every connection you should try sql command ..
SET NAMES UNICODE_FSS;
execute before accessing db.
Just a guess.-
Using following code (untested) should create the needed db file:
ZConnection.Properties.Add(
'CreateNewDatabase=CREATE DATABASE 'C:\firebirddb.FDB' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 4096 DEFAULT CHARACTER SET UNICODE_FSS');
ZConnection.Connect;
Then for every connection you should try sql command ..
SET NAMES UNICODE_FSS;
execute before accessing db.
Just a guess.-
fabian