Re: psqlODBC text length with no records

On 05/13/2014 07:04 AM, Barry Bell wrote:
> Hi:
>    When calling PostgresODBC (ver 9.2.1) using the following settings for VFP(Foxpro)
> BI=2;TextAsLongVarchar=1;UnknownSizes=2;UseServerSidePrepare=1;B0=254;B7=1;C5=0;AB=8;" && Debug=1;B2=1
>
> Select initcap(name) cname from customers   (where name is type varchar)
> If records are returned, Returns pname as the varchar of length of the field (varchar 30 in this case)

So I am going to assume you mean cname above.

> But if I run
> Select initcap(name) cname from customers where 1=0 (no records returns)
> If no records return, cname field as "Memo" (like a CLOB) or longvarchar
>
> In my connection string, I am setting B0=254 meaning any strings under 254 chracter should be varchar and over 255
shouldby longchar type(Memo). 
> And any unknown as longchar type(Unknownsizes=2)

Well according to here:

http://psqlodbc.projects.pgfoundry.org/docs/config.html

you should not  need to use Unknownsizes for 6.4+ versions of Postgres
or if you do use Maximum.

>
> I cannot find any setting that will return the cname field as a varchar (short char), instead of a longchar
type(Memo,CLOB) 
>
> Any ideas?
>
> Barry Bell
>



--
Adrian Klaver
adrian.klaver@aklaver.com