Hermes grumbled and spat out a pure ANSI query:
Karl smiled. “It works.”
The moment of truth came at 2:00 PM. Karl hit the "Run Report" button on Hermes’s green-screen terminal. postgresql ansi odbc driver
Karl pulled up another document. “The regular driver, ‘PostgreSQL Unicode,’ expects UTF-8 strings and modern SQL. Hermes sends data in legacy 8-bit ASCII and uses old-style outer joins with = and * instead of LEFT JOIN . The ANSI driver handles all that legacy baggage. It even translates {fn NOW()} into CURRENT_TIMESTAMP .” Hermes grumbled and spat out a pure ANSI
Hermes grumbled and spat out a pure ANSI query:
Karl smiled. “It works.”
The moment of truth came at 2:00 PM. Karl hit the "Run Report" button on Hermes’s green-screen terminal.
Karl pulled up another document. “The regular driver, ‘PostgreSQL Unicode,’ expects UTF-8 strings and modern SQL. Hermes sends data in legacy 8-bit ASCII and uses old-style outer joins with = and * instead of LEFT JOIN . The ANSI driver handles all that legacy baggage. It even translates {fn NOW()} into CURRENT_TIMESTAMP .”