Re: psqlODBC generating incorrect SQL?

From: "Michael Shulman" <shulman(at)math(dot)uchicago(dot)edu>
To: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC generating incorrect SQL?
Date: 2006-02-23 13:50:23
Message-ID: c3f821000602230550s73a2cd2cn9804433454dffa85@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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 <luf(at)pzkagis(dot)cz> wrote:
> Fri, Feb 17, 2006 at 09:41:07AM -0600, Michael Shulman napsal(a):
> > On 2/17/06, Ludek Finstrle <luf(at)pzkagis(dot)cz> 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
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ellen Cyran 2006-02-23 16:17:49 Access as a front-end or another query builder
Previous Message Mark Morgan Lloyd 2006-02-23 13:07:47 Re: ODBC and pgpool