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

Can't Change Table Type

forums › forums › SQLyog › Using SQLyog › Can't Change Table Type

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 4, 2007 at 6:58 am #23329
      peterlaursen
      Participant

      On MyISAM a KEY can only be 1000 bytes.  Do you use a BLOB/TEXT field for a key?  I think so!  Then you must specify a KEY lenght of max. 1000 before you can change table type.

      Do so from table context menu .. manage indexes .. edit the index

    • February 8, 2007 at 8:37 pm #23330
      j_freeman
      Member

      Ah, of course. Thanks! 🙂

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.