Skip site navigation (1) Skip section navigation (2)

Re: Windows, ODBC drivers and strange points ...

From: Marten Feldtmann <m(dot)feldtmann(at)t-online(dot)de>
To: Josef Springer <Josef(dot)Springer(at)JOOPS(dot)COM>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Windows, ODBC drivers and strange points ...
Date: 2005-10-10 10:45:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Actually this is still a point I have to investigate. To made
all stuff working in a correct way I need another information
about how much bytes actually used ... or I need an information
that I have to deal with UNICODE stuff.

Within the ODBC driver interface I deal with cbLength and
cbPrecision (information delivered by the ODBC drivers). The
first one tells the interface, how much  bytes are reserved
for this column and cbPrecision tells me, what was the length
when executing the create statement.

Therefore under PostgreSQL it's:

For CHAR(15), cbLength is ALWAYS 30 and cbPrecision is always

Both information are not enough - I need to know, how much of
cbLength of this buffer I must use to create the string (and
of course how to interpret the byte stream: single byte character
or doubule byte character) - or cbLength changes it's value
depending on the

Perhaps it would be better to have

CHAR(15) -> cbLength = 15, cbPrecision = 15 (if single-byte database)
CHAR(15) -> cbLength = 30, cbPrecision = 15 (if unicode database)

but there also seem to be other parameters within the ODBC
specs to get this information - I just have not found the overall


Josef Springer schrieb:

> Hi Marten,
> i am using  PostgreSQL 8.0.3 an  ODBC with VisualWorks 7. I am 
> using a UNICODE database (with the same client connect datatype) and 
> all works fine because of the result data aspect. It seems, that other 
> than UNICODE make problems in any case.
> Josef Springer

In response to


pgsql-odbc by date

Next:From: Marten FeldtmannDate: 2005-10-10 11:11:04
Subject: Re: Windows, ODBC drivers and strange points ...
Previous:From: Dave PageDate: 2005-10-10 08:30:36
Subject: Re: Windows, ODBC drivers and strange points ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group