#73 Cannot include escaped quote in SQL statement

closed-rejected
Heiko Hilbert
None
5
2009-11-15
2009-10-11
Anonymous
No

When inserting a VARCHAR or TEXT field, the editor throws an "Unterminated string literal" error. See attached code for example.

Discussion


  • Anonymous
    2009-10-11

    SQL file that will produce error when executed in SQLExplorer

     
    Attachments
    BugExampleCode.sql

  • Heiko Hilbert
    Heiko Hilbert
    2009-10-12

    SQLExplorer currently supports only escaped qoutes by doubling.
    Change your script at line 98 from:
    'Supportin her man\'s dream chasin!'
    to
    'Supportin her man''s dream chasin!'
    and it works.
    This works with MySql-Client too.

     

  • Heiko Hilbert
    Heiko Hilbert
    2009-10-12

    • assigned_to: nobody --> hhilbert
     

  • Heiko Hilbert
    Heiko Hilbert
    2009-11-15

    • status: open --> closed-rejected