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