Backslashes disapearing after my vb.net query to Mysql <p>I'm having some problems, when I do my query from my vb.net program to my mysql DB the data is sent, but its missing some things, let me explain.</p> <p>My query is pretty simple I'm sending a file path to my DB so that after I can have a php website get the data and make a link with the data from my DB, but when I send my data the results look like this...</p> <pre><code> \server_pathappsInst_pcLicences_ProceduresDivers estCheck_list.doc </code></pre> <p>which should look like</p> <pre><code> \\server_path\apps\Inst_pc\Licences_Procedures\Divers\test\Check_list.doc </code></pre> <p>I don't know if its my code that's not good or my configurations on my mysql server please help...</p> <p>Here's my code</p> <pre><code> 'Construct the sql command string cmdString = "INSERT into procedures(Nom, Lien_Nom, Commentaires) VALUES('" &amp; filenameOnly_no_space_no_accent &amp; "', '" &amp; str_Lien_Nom_Procedure &amp; "', '" &amp; str_commentaires_Procedure &amp; "')" ' Create a mysql command Dim cmd As New MySql.Data.MySqlClient.MySqlCommand(cmdString, conn) Try conn.Open() cmd.ExecuteNonQuery() conn.Close() Catch ex As MySqlException MsgBox("Error uppdating invoice: " &amp; ex.Message) Finally conn.Dispose() End Try </code></pre> <hr> <p>Sorry I got a call and could continue my comment so here's the rest :X</p> <p>Well I guess that would work, but my program never uses the same path since in uploading a file on a server, so this time the document I wanted to upload was this path </p> <pre><code> \\Fsque01.sguc.ad\apps\Inst_pc\Licences_Procedures\Divers\test\Check_list.doc </code></pre> <p>but next time its going to be something else so I can't hard code the paths, I was looking more of a SQL query which that I might not know, since I already thought about searching my string and if it finds a backslash it adds another one, but I feel its not a good way to script the whole thing...</p> <p>Anyway thanks a lot for your help</p>