for datatype var char no result size

for datatype varchar always returns 4 instead of the maximum number of characters!!!

Would you e-mail to Support the table DDL and query that can be used to reproduce the issue?

Thank you!

//table is very simple
CREATE TABLE adresy_dost
(
key_id serial NOT NULL,
kontrah character varying(20) DEFAULT ''::character varying,
id_kontrah integer,
adres character varying(200) DEFAULT ''::character varying,
adres_full character varying(255) DEFAULT ''::character varying,
CONSTRAINT adresy_dost_pkey PRIMARY KEY (key_id)
)

// for all vatchar return size of field = 4
// insted of 21 for field ''kontrah''
// 201 for field ''adres''

I used MSADO and there it works correctly. I wanted to change for Postgres but it will not let me. I need this to control how many max characters user can type in the application desktop.

What version of the PGNP Provider are you using? I have not been able to reproduce the issue with the latest build.

The provider returns columns schema, columns information, and columns rowset from result, with all sizes correctly.