in reply to Re^4: escaping special characters in mysql queries
in thread escaping special characters in mysql queries

just an update.. if my string value is: be prepared! you can't do that 'may be i will do it'.
it is giving output as expected..i.e full string..
  • Comment on Re^5: escaping special characters in mysql queries

Replies are listed 'Best First'.
Re^6: escaping special characters in mysql queries
by Happy-the-monk (Canon) on Nov 22, 2004 at 11:40 UTC

    It seems I was guessing somewhat right then.
    Try assigning your string with the q// quoting operator; example:

    ... = q/be prepared! you can't do that "may be i will do it"./

    Turn on warnings, too.

    Cheers, Sören