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

Поиск
Список
Период
Сортировка
От Hu, Ming (Ivan)
Тема Re: Why SQLBindCol can not get back the c string length.
Дата
Msg-id 31C0F08B0D18D511ACC800508BAE7B4714581BC4@ci0026exch001u.bj.lucent.com
обсуждение исходный текст
Ответ на Why SQLBindCol can not get back the c string length.  ("Hu, Ming (Ivan)" <huming@lucent.com>)
Ответы Re: Why SQLBindCol can not get back the c string length.  (Ludek Finstrle <luf@pzkagis.cz>)
Список pgsql-odbc
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

В списке pgsql-odbc по дате отправления:

Предыдущее
От:
Дата:
Сообщение: [ psqlodbc-Bugs-1000687 ] Problem with WHERE and upercase character
Следующее
От:
Дата:
Сообщение: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access