Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    11

    Unanswered: A small sql question

    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

  2. #2
    Join Date
    Nov 2003
    Location
    Russia
    Posts
    7
    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

  3. #3
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •