PostgreSQL - 7.1.3 (installed on Linux 2.4.2-2)
PSQLODBC.DLL - 07.01.0007
Visual C++ - 6.0
---
The below SELECT SQL was ran from the command line:
mydb=# SELECT a FROM b WHERE c = 'WORKGROUP\me'
Result = Zero rows returned.
mydb=# SELECT a FROM b WHERE c = 'WORKGROUP\\me'
Result = One row returned.
---
And from my C app.
strcpy(strID, "WORKGROUP\\me");
Result = Zero rows returned.
strcpy(strID, "WORKGROUP\\\\me");
Result = One row returned.
The PostgreSQL ODBC driver cannot handle backslash character ??? - I have to
escape it myself.
Can someone confirm this to be a bug please.
Thanks.
Andy
ahm@exel.co.uk