View Single Post

   
  #3 (permalink)  
Old 04-16-2008, 02:51 AM
Michael Shulman
 
Posts: n/a
Default Re: psqlODBC generating incorrect SQL?

On 2/17/06, Ludek Finstrle <luf@pzkagis.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.

Best,
Mike

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote