| 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 13:22:42 |
| Message-ID: | 53736E22.4090506@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On 05/14/2014 06:11 AM, Barry Bell wrote:
> Use the cast work fine but we are using the initcap function in a lot of places
> And do not want to cast to every place.
> (Plus we use a lot of other functions that may have the same issue).
>
> You said the initcap function return "text",
> Is this a "short" text like a varchar
> Or a long text like a clob,memo etc?
This is text vs varchar(n) or char(n). I show the 'n' because in
Postgres a varchar without a length is equivalent to text. See here for
all the details:
http://www.postgresql.org/docs/9.3/interactive/datatype-character.html
>
> 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
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Bell | 2014-05-14 13:31:07 | Re: psqlODBC text length with no records |
| Previous Message | Barry Bell | 2014-05-14 13:11:58 | Re: psqlODBC text length with no records |