Re: 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