Re: Strange ODBC behavior.

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