Page 1 of 1

zeos and unicode

Posted: 10.07.2006, 09:20
by sancho1980
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

Posted: 10.07.2006, 09:42
by Terence
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.-