Thread: Odbc bug ?

Hi,
I dont know if this is about the same thing, but the SQL below returns different data types in
psqlOdbc 8.00.01.02 and 8.01.02.00

SELECT 'TX' AS tpitem;

psqlOdbc 8.00.01.02 return a varchar(254) field
and psqlOdbc 8.01.02.00 return a 'Memo' field
in both cases Max VarChar is set to 254

I´m using Visual FoxPro ( same behavior in VFP 7.0 and VFP8.0 )

This can be considered a bug ?

Thanks in Advance

Luiz


Ludek Finstrle wrote:

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

---------------------------(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