Re: Data Types in 8.00.01.02

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Dave Held <dave(dot)held(at)arraysg(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Data Types in 8.00.01.02
Date: 2006-03-22 11:09:46
Message-ID: 20060322110946.GB6294@soptik.pzkagis.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2006-03-22 11:19:51 Re: Future development
Previous Message Ludek Finstrle 2006-03-22 11:02:35 Re: Support for PostgreSQL 8.1.3 stable