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


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to