Re: ODBC, access, and joins

On Fri, Nov 23, 2007 at 03:48:01PM -0500, Tom Hart wrote:
> The problem I'm having is that anything defined as a
> "text" datatype in postgres gets converted to a "memo" datatype in
> access, and when we attempt to perform a join query on that field access
> starts complaining about not being able to join on a field with a "memo"
> type. I think this might be a bug in the odbc driver, but I want to
> check my bases. Has anybody else run into this issue, or heard anything
> about the odbc driver having problems with datatypes in access?

For the text-memo thing there are options in the configuration (a
tickbox xsomewhere). I think it's called text-as-varchar switch or
something. There were some other config options that I also changed,
but it's been too long ago to give anything specific.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy