Dropped "\" in string using ODBC and Visual C++

[siftach]

I recently moved from MS Access to MySQL and discovered a small problem with strings containing "\". If I insert such string to a database using an ODBC connector with Visual C++, all the "\" are dropped. For example: "Z:\Mertel\Saturn" becomes "z:MertelSaturn".

However, if I link that table in an MS Access database and use the MS Access ODBC connector, I don't get this problem. But I don't want to use anoter layer of ODBC just to solve this problem.

How can I solve this problem *without* changing my string before insertion?

 

[sleipnir214]

Nope.

The backslash disappears because that character is used by c-langage (and thus C++) as its escape character. If you need those backslashes to traverse through c, you're going to have to convert them to double-backslashes.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[siftach]

I already double backslashed to get the original string, I can't go over all my SQL strings and redouble backslash them. There must be a simpler solution.