Re: Why SQLBindCol can not get back the c string length.

Thanks for your response.

I mean after calling SQLFetch(), the value could not be gotten.

-----Original Message-----
From: Ludek Finstrle [mailto:luf@pzkagis.cz]
Sent: Monday, July 24, 2006 5:07 PM
To: Hu, Ming (Ivan)
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Why SQLBindCol can not get back the c string length.


> Why I can not get the actual length from StrLen_or_IndPtr,the last
paramter
> of SQLBindCol(). The value of it always keep the input one.

When you want to get the value? You can't get it after SQLBindCol() call.
Please read the specification at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/od
bcsqlbindcol.asp

If I misunderstand your notice please correct me.

> Also, for varchar string, the return c string is with right length, while
> for fixed chars in DB, the returned c string is
> always with the fixed char length in DB, there are space appended in c
> string.

I see you have no clue what's the difference betwwen char and varchar
type in PostgreSQL. Please read the PostgreSQL manual. It isn't ODBC
related (http://www.postgresql.org/docs).

Regards,

Luf