Re: psqlODBC generating incorrect SQL?

Yes, it is very simple.  Just create a Unicode database and then try
to connect to it from an ANSI data source.

On 2/17/06, Ludek Finstrle  wrote:
> Fri, Feb 17, 2006 at 09:41:07AM -0600, Michael Shulman napsal(a):
> > On 2/17/06, Ludek Finstrle  wrote:
> > > Are you both using same psqlODBC driver (version ant type - ANSI vs.
> > > Unicode)?
> >
> > That was it!  She had it set to ANSI and mine (and the database) is
> > Unicode.  Changing hers to unicode fixes it.  Thanks!
> >
> > It would be nice if the driver could give a more informative error
> > message if this happens, though.  I never would have guessed that
> > would cause a problem like this.
>
> I tried only some shots into dark. I have no idea what's happen.
> Are you able simulate the problem on your computer? Or even better
> could you create minimalistic application which reproduce the problem
> and send it to me?
>
> Regards,
>
> Luf
>