List: General Discussion « Previous MessageNext Message » From: Wolfram Kraus Date: October 19 2004 9:38am Subject: Re: Preserving backslashes in DML View as plain text
Tom Kirkman wrote:
> What are the options available for inserting\updating a MySQL table
> VARCHAR with a string containing backslash characters so that the
> backslash characters are preserved as is?  For example, the UNC string
> '\\MyServer\MyDir <file:///\\MyServer\MyDir> ' would be changed on the
> way in to the VARCHAR to become '\MyServerMyDir'.  What options are
> there for specifying that this changing on the way in should NOT be
> done?
>
Just mask every backslash with another backslash:

'\\\\MyServer\\MyDir'

http://dev.mysql.com/doc/mysql/en/String_syntax.html

HTH,
Wolfram

Thread
Preserving backslashes in DMLTom Kirkman19 Oct
• Re: Preserving backslashes in DMLWolfram Kraus19 Oct