I am trying to store a link to a document in a mysql database using VB.NET. I open a file browser for the user to select the file, and if I output the returned filename to a messagebox it looks fine, but when I write that filename string to the SQL database it removes all of the backslash characters.
The messagebox output shows my filename string to be: C:\Temp\EULA.TXT
The field in the SQL database is: C:TempEULA.TXT
Is there a special data type I need to use (either in VB.net or in mysql) to store the filepathname? How can I stop it stripping out the '\' characters. I am currently storing it as a String in VB and as varchar(255) in mysql. Please note I am not trying to upload a file into the database, just store the filename and path.