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

Perhaps you might remember my tests with
PostgreSQL and IBm VisualAge Smalltalk.

I mentioned my problems with column lengths
and stuff like this.

 I still testing (from time to time) with
the 8.0.3 database and use the newest
8.01.00.03 libpq ODBC drivers and now
the situation is getting worse :-((((

 IBM Smalltalk is now not able to get the
correct column size for strings any more.

 I always get either 254 bytes or 508 bytes
as column size.

 We have a table like:

create table "TPERSON" ("ALLCSTVIEW" CHAR(1)
....

 Now IBM Smalltalk calls OdbcSQLDescribeCol
and gets 254 for this column as size in the
return parameter cbPrecision.

 And the alternate call via OdbcSQLColAttribute
with parameter Sql_Column_Lengthreturns  508.

 Actually this is true for ALL string columns

 The PostgreSQL drivers seem strange for me ...
I've done work with other database systems
via this ODBC library, but PostgreSQL does
not give me any real success ....

 If anyone has any help ....

 Marten

>
>
> b) All strings returned by the ODBC driver are defined
>  in a buffer, which is offered to the ODBC subsystem
>  as a string doubled in size - though I told the
>  databaase NOT to create a UNICODE db.
>
>  An example: a column has the result type char(15). The
>  ODBC drivers put the result of this column into a
>  memory with a size of 30 characters.
>
>  The ODBC subsystem now thinks: fine - I've a character
>  column with size 30 and creates a string 30 characters
>  long and one gets 15 corrects characters and 15 "0" (null)
>  bytes.
>
> I've never seen this behaviour with other ODBC drivers
> I've used so far, therefore I think, this is pretty
> strange behaviour.
>
> I'm using the 8.0.3 database and the 8.0.1.2 drivers.
>
> Any ideas ???
>
>
> Marten Feldtmann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>


--
Marten Feldtmann - Germany - Software Development
Information regarding VA Smalltalk and DMS-system
"MSK - Mien Schrievkrom" at: www.schrievkrom.de