Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    15

    Unanswered: How do I get a single quote into a VARCHAR field?

    Hello,

    I have the Problem, that I want to put a _'_ single quote into a varchar field.
    Because I have to put the text for the field into single quotes, the one inside my text, breaks the statement.
    I tried to put the text into _"_ double quotes but that produces an odd error message.
    There are a lot of textfields I have to fill with my statement and all the other got single quotes around their values only the one field that has to contain a text with a singel quote in it was surroundes with double quotes.

  2. #2
    Join Date
    Aug 2006
    Posts
    15
    pad it with another single quote, stupid
    _'_ => _'_'_
    thanks to myself

  3. #3
    Join Date
    Oct 2005
    Posts
    30
    lucky you!
    till now, my question here never really get replied.

Posting Permissions

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