I would like to insert these strings:
C:/Documents and Settings/wendysia/Desktop/logo.jpg

into my database(mysql) with the field type of VarChar(80)

However, when the insert is done. I found out that the "/" character has been eliminated into
Cocuments and SettingswendysiaDesktoplogo.jpg


Is there any problem with my Insert query?
VB Code:
  1. insertPhoto = "UPDATE employee SET photo = '" & Picpth & "' WHERE Emp_ID ='" & ID & "'"