for datatype var char no result size

More
5 years 1 month ago #10913 by SF
SF created the topic: for datatype var char no result size
for datatype varchar always returns 4 instead of the maximum number of characters!!!

Please Log in or Create an account to join the conversation.

More
5 years 1 month ago #10916 by Moderator
Moderator replied the topic: Re: for datatype var char no result size
Would you e-mail to Support the table DDL and query that can be used to reproduce the issue?

Thank you!

Please Log in or Create an account to join the conversation.

More
5 years 1 month ago #10918 by SF
SF replied the topic: Re: for datatype var char no result size
//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.

Please Log in or Create an account to join the conversation.

More
5 years 1 month ago #10920 by Moderator
Moderator replied the topic: Re: for datatype var char no result size
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.129 seconds
Powered by Kunena Forum