Re: Strange ODBC behavior.

[Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>]

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