At 9:10 AM +0100 9/12/01, Peter Gad wrote:
>Hi everyone !
>
>We've got a problem:
>running mySQL on unix(sun) we connect a third party
>windows software over ODBC. All is nice until a windows path
>is stored in the db
>
>Trying to store "C:\Program Files\3p SW\"
>
>I find that it becomes "C:Program Files3p SW".
>
>Is it possible, by means of configuration, to have backslashes preserved ?
>Either in ODBC or ... somewhere ?
Backslash is escape character; to store a string containing one, you
have to double it. For example, use the string
C:\\Program Files\\3p SW\\
is your INSERT query, and it will show up in your SELECT result as
C:\Program Files\3p SW\
>Facts:
>3d party software = no code no chance of changes
>ODBC - installed from myodbc-2.50.37-nt.zip
>mySQL - 3.23.39 ( 3.23.41 could be used)
>
>thanx in advance
>peter
>
--
+------------------------ Open source questions? ------------------------+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+----------- http://pgfsun.ucdavis.edu/open-source-tools.html -----------+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
