Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    87

    Unanswered: Question about using " and ' in a field.

    Hello,

    Quick question about using " and ' within a field. I have a list of keywords, some of which have quotes, symbols for inches i.e. " and symbols for feet i.e. '.

    I would like to leave them in there. So the question is, can I leave them in there and successfully export my Access dB to a CSV so that it can later be imported in a MySQL dB?

    I guess my concern is that if there is a quote, inch or foot character, that it will cause conflicts upon export and or import.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    this will bit you in the backside.
    as a general rule use ' to delimit strings
    eg
    myvariable = 'this is an example'
    although with Access you can use " as well
    theoretically you can use "" to use the " symbol inside text. but it can get messy very quickly, especially if you are intending pumping data into another database. I'd strongly recommend you use ft in in place of ' " eg 6ft4in, or leap forward into the 19th century and use the metric system for measurements eg 1.88m . the problem is not storing the data in Access, or in MySQL its pushing it from Access to MySQL. you can get round it by telling Access to export the file using another symbol to delimit strings and tell MySQL to use the same symbol to import strings. its a mess
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2010
    Posts
    87
    fair enough

    but does using " and ' within things like a product description get nasty too? I mean, can I use it anywhere? (this dB is about to have no " or ' in it anywhere! LOL) TABLEWIDE deletion is coming! Expect a post for it. lol



    Why didn't someone come up with a delimiter such as open and close brackets for data moving. Like <!openfield> </closefield!> for open and close field. That way there's no doubt that it's the container!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there is, however not all databases use the same symbol
    google escape characters

    you shoul be abel to get away with \" or \' as an escape symbol for inserting into MySQL
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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