MS Access (ODBC) character escaping...~mysql_escape ??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Jet Black
Forum Newbie
Posts: 4
Joined: Sat Jun 03, 2006 7:53 pm

MS Access (ODBC) character escaping...~mysql_escape ??

Post by Jet Black »

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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

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.
Jet Black
Forum Newbie
Posts: 4
Joined: Sat Jun 03, 2006 7:53 pm

Post by Jet Black »

Yeah, I'd assumed that since ODBC works on more than one DB, there must be an "ms_access_escape" or ms_jet_escape somewhere....I hate how ms escapes things its just wrong....so wrong
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Hence the lack of a wide range of support for their stuff in the open source community. :wink:
Jet Black
Forum Newbie
Posts: 4
Joined: Sat Jun 03, 2006 7:53 pm

Post by Jet Black »

Everah wrote:Hence the lack of a wide range of support for their stuff in the open source community. :wink:
Ugh.

Tell me about it.
Post Reply