| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Barry Bell <Barry(dot)Bell(at)hartehanks(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:27:09 |
| Message-ID: | 53738B4D.1030507@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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 | Barry Bell | 2014-05-14 15:29:13 | Re: psqlODBC text length with no records |
| Previous Message | Barry Bell | 2014-05-14 14:42:36 | Re: psqlODBC text length with no records |