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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>