Re: Data Types in 8.00.01.02 - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Data Types in 8.00.01.02
Date
Msg-id 20060322110946.GB6294@soptik.pzkagis.cz
Whole thread Raw
In response to Data Types in 8.00.01.02  ("Dave Held" <dave.held@arraysg.com>)
List pgsql-odbc
> In BusinessObjects XI Business View Manager, any varchar() field
> larger than varchar(254) shows up as a "Persistent Memo" type.  Is this
> because the ODBC driver is doing something funny when it sends over
> metadata, or is this a BOXI issue?

The ODBC driver the best what it can. But yes the problem is on PgSQL and
psqlODBC driver side. When ODBC driver ask for result types PgSQL backend
answer text type. This is the real "problem".

You are able to change quite the behaviour with setting Max Varchar (size).

Regards,

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Support for PostgreSQL 8.1.3 stable
Next
From: Ludek Finstrle
Date:
Subject: Re: Future development