i am trying to insert data into sql database and the data comes from a file and gets transferred directly to the database. the problem is that one of my fields is to collect pathnames. now whenever the data reaches the databases the slashes are gone
for ex if the path in the datafile is like \\rhino\users\vol1\sim
then in the database it will be like \rhinousersvol1sim

one way to correct is like adding one more \ after every \ but since it going directly i can't, i was just wondering if there is a way to tell the sql to ignore the slashes

any ideas guys

if you can't change data, change scripting... let data file dumping in some directory, some script proccess it and insert into DB...

or you must arranging with data vendor

How is it loading the data?

If you're using LOAD DATA LOCAL INFILE you can change the ESCAPED BY setting from \ to something else.

http://www.mysql.com/doc/en/LOAD_DATA.html

Matt.