Field size problem with linux and firebird
lazarus / 16-Databases

----------------------------------------------------------------------
cappe · 2020-06-17 09:45

I use lazarus 1.8.0 for linux x64 and zeos 7.2.6 and firebird 2.5. The
database has WIN1252 as a code page.

ZConnection is set:
ClientCodePAge WIN1252
ControlsCodePage cCP_UTF8

ZQuery.SQL is "select * from home"

I click twice on ZQUERY and add the static fields.

The problem is that the size is wrong. For example
The "ID" field
In the DB it is varchar (10)
in lazarus it assigns me size = 40. This creates problems when I
insert long strings generating exception in the database.

How can I solve it?

----------------------------------------------------------------------
mangakissa · 2020-06-18 06:28

You can't. It's a conversion problem. I have the same with UTF-8. I
Manually override it to actual size.