psqlODBC text length with no records

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)
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 should by longchar type(Memo).
And any unknown as longchar type(Unknownsizes=2)

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

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Hiroshi Saito
Sent: Tuesday, May 13, 2014 9:20 AM
To: Michael Paquier; Hiroshi Inoue
Cc: Heikki Linnakangas; Anna Gershnik; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] psqlODBC msi download for Heartbleed

Hi all.

Sorry very late reaction.
Ooops, Openssl version that is provided was 1.0.1f....:-( I would release to adjust with Inoue-san soon.

(2014/05/13 19:32), Michael Paquier wrote:
> On Tue, May 13, 2014 at 6:11 PM, Heikki Linnakangas
> <hlinnakangas(at)vmware(dot)com> wrote:
>> On 05/12/2014 10:01 PM, Anna Gershnik wrote:
>>>
>>> Hi,
>>>
>>> I was wondering when a new download with a fix for Heartbleed
>>> vulnerability will be available?
>>> The latest available here is from March 8, 2014:
>>> http://www.postgresql.org/ftp/odbc/versions/msi/
>>
>>
>> Oh, I didn't realize we ship the SSL libraries in the installer.
>> Yeah, we should update those ASAP.
>>
>> Hiroshi, others, can we put out a new release, with updated SSL
>> libraries, please?
> Yeah, that's definitely something we should do.
>
>> Where exactly do the libraries come from, i.e. what is the upstream
>> project? If there's anything I can do to help, let me know.
> I was planning to have a look at the msvc specs of odbc soon... But
> could not really find the time. Btw, I would assume that the openssl
> libs come from here:
> http://slproweb.com/products/Win32OpenSSL.html
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc