Create Macro %FullPath_CStyle% to avoid backslash ODBC prob.

[Bob]

I am trying to log full path names to a mysql database. Backslashes need to be doubled as in \\Root\\Myfolder. This feature would be similar to %Reply_CStyle% macro.

Other workaround suggestions would be appreciated!

Thanks
Bob Roswell

[KS-Soft]

I know that some SQL servers require double backslash but I am not sure about SQL 92 standard. Trying to find quote... May be you have quote from the manual right on hand?
If \\ is not required by SQL 92, it should be implemented as option.

Regards
Alex

[bob]

that most systems in real life treat the \ as an escape character.

[broswell]

# SERVER SECTION

# ----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure that

# you have installed the server correctly (see above) so it reads this

# file.

#

[mysqld]

sql-mode=NO_BACKSLASH_ESCAPE