Re: Bug? Data Type Option 'Text as LongVarChar' not working anymore?

Hi,

On 2017/09/13 20:13, Jan-Peter Seifert wrote:
> Hello,
>
>> Gesendet: Mittwoch, 13. September 2017 um 02:05 Uhr
>> Von: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
> ...
>> I can see the effect of 'Text As LongVarChar' here.
>> Could you tell me unexpected behavior more concretely?
> Test case:
> 1. Create a DSN choosing 'PostgreSQL Unicode'
> 2. Call ODBC-function SQLColumns(...) for a column of data type 'text'.
>
> Expected results as for e.g. version 09.03.04.00:
> a) Option "Text As LongVarChar" NOT set => data type "SQL_WVARCHAR (-9)"
> b) Option "Text As LongVarChar" set => data type "SQL_WLONGVARCHAR (-10)"

How do you set *Unknown Sizes*, *Max Varchar* and *Max LongVarChar*?

regards,
Hiroshi Inoue

> Newer psqlODBC versions (e.g. 09.06.04.00 / 09.06.04.10 / 09.06.05.00) always return data type "SQL_WVARCHAR (-9)" - irrespective of the 'Text As LongVarChar' setting.
>
> I know that technically text is varchar without a length limit, but our software has to differentiate between these two data types.
>
> Best regards,
>
> Peter