View previous topic :: View next topic |
Author |
Message |
Bob Guest
|
Posted: Wed May 04, 2005 7:53 pm Post subject: Create Macro %FullPath_CStyle% to avoid backslash ODBC prob. |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Thu May 05, 2005 3:40 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
bob Guest
|
Posted: Mon May 09, 2005 8:31 am Post subject: DOn't know about the standard, but can document |
|
|
that most systems in real life treat the \ as an escape character. |
|
Back to top |
|
|
broswell
Joined: 04 May 2005 Posts: 7
|
Posted: Mon Jun 06, 2005 12:08 pm Post subject: Found a fix for MYSQL |
|
|
# 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 |
|
Back to top |
|
|
|