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