[ psqlodbc-Bugs-1000744 ] 08.02.01: Incorrect size returned for adVarWChar and adVarChar fields afte

Bugs item #1000744, was opened at 2006-10-04 13:42
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 44&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Adam Biser (adambiser)
Assigned to: Nobody (None)
Summary: 08.02.01: Incorrect size returned for adVarWChar and adVarChar fields after Paremeters.Refresh.

Initial Comment:
I'm using VB6 on a Windows XP machine with ODBC driver 08.02.01 and PostgreSQL 8.2beta1.

CREATE TABLE testtable
(
code integer NOT NULL,
testfield character varying(5000),
CONSTRAINT proschargemstrpk PRIMARY KEY (proschargecode)
)

When I use a Command object, set the CommandText, and perform a .Parameters.Refresh, the .Size of testfield's parameter is 254 instead of 5000 and setting the .Value of the parameter to anything longer than 254 characters results in an error. This happens with both the Unicode and ANSI drivers.

The create table statement that pgAdmin III gives me is included at the top. If any additional information is needed, I will provide it.

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 44&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend