| From: | Grant Shirreffs <GShirreffs(at)stayinfront(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
| Subject: | Escaped characters in LIKE |
| Date: | 2019-02-25 03:42:45 |
| Message-ID: | BYAPR18MB3029A0A25F290FFB4D1BD139CF7A0@BYAPR18MB3029.namprd18.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
PostgreSQL fully supports escaping of %, _ and \ in LIKE clauses, and supports the standard syntax for indicating the use of an escaping character: https://www.postgresql.org/docs/9.0/functions-matching.html.
The ODBC driver correctly supports the standard ODBC 'escape' syntax for declaring the escaping character: (convert.c, line 5580).
So is there some reason I'm missing why the SQLGetInfo implementation, when asked SQL_LIKE_ESCAPE_CLAUSE, says that the driver doesn't support escaping of LIKE? (info.c, line 309). There is a comment in the code that indicates that the author wasn't aware of the SQL syntax ('is there a character that escapes '%' and '_' in a LIKE clause? not as far as I can tell').
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Skovorodnikov Aleksey | 2019-02-25 15:33:02 | I want to know if the ODBC is installed on my computer |
| Previous Message | Nathan Harrell | 2019-02-22 13:33:07 | Potential Windows ODBC 10.03.0000 Security Vulnerability |