Re: psqlODBC text length with no records

Sending the SQL through the postgres driver to a Postgres ver 9 server, where it runs,
I see the data types in the client software that is calling the ODBC driver
(in this case VFP, foxpro).


Barry Bell
Senior Developer/Analyst
Logistics
Harte Hanks
1525 NW 3rd ST
Deerfield Beach FL, 33442
954-429-3771 Ext 267 office
954-281-1464 fax

hartehanks.com / linkedin / twitter / facebook

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Wednesday, May 14, 2014 11:27 AM
To: Barry Bell; Hiroshi Saito; Michael Paquier; Hiroshi Inoue
Cc: Heikki Linnakangas; Anna Gershnik; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] psqlODBC text length with no records

On 05/14/2014 07:29 AM, Barry Bell wrote:
> Behavior seems different if you get the text from table vs fixed value.
>
> The  select 'ABCDE' from dual   return a text(longchar, memo),
> The select initcap(varcharfield) from varchartable  returns varchar
> The select initcap(varcharfield) from varchartable where 1=0  returns
> text(longchar, memo),

Where are you determining the data types?

In other words you run the SQL where and you see the output and data type where?


>
>
>
> Barry Bell


--
Adrian Klaver
adrian.klaver@aklaver.com