I'm assuming this is a real simple one, but I can't seem to come up with an answer by seraching...maybe I don't know what to look for.
I need an equivalent of mysql_escape for ms access using ODBC. I'm assuming this allready exists or else it makes it quite impossible to use access to store user text.
THanks
MS Access (ODBC) character escaping...~mysql_escape ??
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
I don't think there is an odbc equivalent escape function. And I think it has to do with the fast that you can use ODBC functions to hit almost any kind of database. Since each database handles escapes differently you cannot apply a unilateral escape application. I think this is the answer, though I would suggest more research.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA