Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Bug: Adding Enum Value With Embedded Sinqle Quote

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Bug: Adding Enum Value With Embedded Sinqle Quote

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • March 3, 2011 at 9:43 pm #12266
      Mitch
      Participant

      Using the alter table dialog to add an enum value that includes a single quote causes an SQL error. It needs to double up the embedded single quote.

    • March 3, 2011 at 10:37 pm #31992
      peterlaursen
      Participant

      OK .. we will check this (report looks reasonable). But if you-yourself double the quote it is OK?

    • March 4, 2011 at 12:03 am #31993
      Mitch
      Participant

      If I take the failing SQL (from history tab) and double the quote myself, it works fine.

    • March 4, 2011 at 6:02 am #31994
      ashwin
      Member

      Hi,

      Quote:
      Using the alter table dialog to add an enum value that includes a single quote causes an SQL error. It needs to double up the embedded single quote.

      Actually, You don't have to add single quote to a value for Enum as SQLyog itself adds single quote for a value. You can just enter a value for Enum without single quote in Create/Alter table.

      Thanks and Regards,

      Ashiwn A

    • March 4, 2011 at 8:44 am #31995
      peterlaursen
      Participant

      @Ashwin .. I do not think you understand! Consider an ENUM-list with values

      * Ashwin's

      * Mitch's

      * Peter's

      The the apostrophe is part of listed strings.

    • March 8, 2011 at 10:33 am #31996
      peterlaursen
      Participant

      This is fixed now. next release (probably by end of this week) will have the fix.

  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.