Page 1 of 1
MS Access (ODBC) character escaping...~mysql_escape ??
Posted: Sun Aug 13, 2006 11:48 am
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
Posted: Sun Aug 13, 2006 7:15 pm
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.
Posted: Tue Aug 15, 2006 9:36 am
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
Posted: Tue Aug 15, 2006 11:48 am
by RobertGonzalez
Hence the lack of a wide range of support for their stuff in the open source community.

Posted: Tue Aug 15, 2006 12:40 pm
by Jet Black
Everah wrote:Hence the lack of a wide range of support for their stuff in the open source community.

Ugh.
Tell me about it.