Here is everything you need to know to get this working on Windows 7. Modern Windows applications use UTF-16 (Unicode). PostgreSQL drivers default to this. However, older applications (often built with Visual Basic 6, older C++, or Delphi) were compiled for ANSI (code pages like Windows-1252).
Bridging the Gap: Using the PostgreSQL ANSI ODBC Driver on Windows 7 postgresql ansi odbc driver windows 7
The standard solution is the PostgreSQL ODBC driver (psqlODBC). However, many users run into a specific hurdle: . If your legacy application doesn't understand Unicode, the standard 64-bit driver won't work. You need the PostgreSQL ANSI ODBC Driver . Here is everything you need to know to