how to store a path in mysql

[jeyanthi]

hi

need help how can we store the path in MySQL

let say C:\Documents and Settings\Administrator\Desktop\JeyA-DOc\Done Softwares\My Pictures\map.jpg is my path

it can insert in the database but aftr inserting all the delimeters disappears...

for example it store like this

C:Documents and SettingsAdministratorDesktopJeyA-DOcDone SoftwaresMy Picturesmap.jpg

[Deepu]

I am not a MySQL user. However a search in their site showed up this page:

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Look for the info: NO_BACKSLASH_ESCAPES

You may need to set it the MySQL in this mode (I am not sure how to do that though)

Hope it helps !

[Ray.R]

It does look like backslash_escape... 

Curious..  Can you show the portion of the code which sends the path to mySQL?  How are you sending the path info?

RayR