From: | "Andy Hallam" <ahm(at)exel(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SELECT with backslash '\' character |
Date: | 2001-10-29 09:58:04 |
Message-ID: | 9rj99q$cth$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)exel(dot)co(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Patrice Hédé | 2001-10-29 10:03:13 | Re: [HACKERS] UNICODE |
Previous Message | Mark kirkwood | 2001-10-29 09:18:38 | More On 7.2 Distributions - Estimates For Number Distinct < 0 |