Size of fields strings in zquery

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
fabiobb.sc
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 18.08.2016, 02:21

Size of fields strings in zquery

Post by fabiobb.sc »

Hi, i am brazilian. My english is poor. Sorry. :[

I using Delphi 7 and using postgresql 9.4 with one database (UTF8) and one table:

CREATE TABLE cadcidade
(
id_cadcidade bigint NOT NULL, -- Sequencial de identificação da cidade.
nome character varying(100) NOT NULL, -- Nome da cidade.
estado character varying(2) NOT NULL, -- Sigla do estado da cidade.
CONSTRAINT pk_cadcidade PRIMARY KEY (id_cadcidade)
);

I start a new project, in delphi 7.
Added TZConnection and configured it .
Added tzquery and configured sql property.
When i add fields, the field estado was add string with property size equals 8 (2 * 4). The original size is 2.

Why ? Please help-me.
Post Reply