Re: Strange ODBC behavior.

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Strange ODBC behavior.
Date: 2007-08-05 23:54:17
Message-ID: 46B66329.3060605@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Adrian Klaver wrote:

> Actually this has been noted before. Search Google or psql-odbc archives for
> references. There are some changes you can make to the ODBC settings to help.
> Unfortunately, I cannot remember them off the top of my head. I only bring
> this up because I saw your post on the general list about changing the type
> of 600 text columns. You might find it easier to change the behavior of the
> ODBC driver.

I should have thought about checking the ODBC settings before.

There is a setting called "Text as LongVarChar" - I've unticked that and
now text fields are coming through as text.

Thanks for the pointers.

--
Paul Lambert
Database Administrator
AutoLedgers

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Paul Lambert 2007-08-06 01:11:07 Re: Strange ODBC behavior.
Previous Message Adrian Klaver 2007-08-05 23:41:18 Re: Strange ODBC behavior.