From: | Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Hiroshi Saito <hiroshi(at)winpg(dot)jp>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Anna Gershnik <agershnik(at)tableausoftware(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: psqlODBC text length with no records |
Date: | 2014-05-14 15:29:13 |
Message-ID: | ddb764a5697b48d494729ea582ceb163@BY2PR08MB281.namprd08.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)klaver(at)aklaver(dot)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(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-05-14 15:38:19 | Re: psqlODBC text length with no records |
Previous Message | Adrian Klaver | 2014-05-14 15:27:09 | Re: psqlODBC text length with no records |