This is a discussion on ODBC and quotes/escape characters within the MySQL Database forums, part of the Database Forums category; Hi -- I am using a freeware program (www.jsdb.org) to access my MySQL database via MS Windows ODBC. Right ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi -- I am using a freeware program (www.jsdb.org) to access my MySQL
database via MS Windows ODBC. Right now I have a problem using jsdb to insert rows with _ and % in their values because jsdb uses the wrong method of quoting/escaping. Assuming I am using MySQL's ODBC driver, is there a way to find out via the ODBC functions (or even via an SQL SELECT statement!) any/all of the following: 1) whether it is MySQL or something else 2) what the quote characters are for field names and values (` and ' respectively) |