Postgres Pro
Downloads
Home   >   mailing lists

Thread: Data Types in 8.00.01.02

Data Types in 8.00.01.02

From
"Dave Held"
Date:

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?

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

Re: Data Types in 8.00.01.02

From
Ludek Finstrle
Date:
> 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