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

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 (view raw or flat)
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

pgsql-odbc by date

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

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