Odbc bug ?

This is a multi-part message in MIME format.
--------------070109080204000706080504
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


Hi,
I dont know if this is about the same thing, but the SQL below returns=20
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=B4m 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 thi=
s
>> because the ODBC driver is doing something funny when it sends over
>> metadata, or is this a BOXI issue?
>> =20
>
> The ODBC driver the best what it can. But yes the problem is on PgSQL a=
nd
> psqlODBC driver side. When ODBC driver ask for result types PgSQL backe=
nd
> answer text type. This is the real "problem".
>
> You are able to change quite the behaviour with setting Max Varchar (si=
ze).
>
> 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 you=
r
> message can get through to the mailing list cleanly
>
>
> =20

--------------070109080204000706080504
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit