[Bug] mySQL- Table Comments should have 60 Char limit

steveb's profile image steveb posted 9 years ago in General Permalink
Just a note that HeidiSQL isn't enforcing the 60 Char limit for comments in mySQL table structures. mySQL will store longer comments it seems, however trying to use the SHOW CREATE TABLE statement will fail if comments are over 60 chars.

Love HeidiSQL!

Thanks!
ansgar's profile image ansgar posted 9 years ago Permalink
HeidiSQL already limits the comment length. But since v5.5.3, MySQL allows up to 2048 characters in a comment. You are probably on a newer server.

SHOW CREATE TABLE shows me the full 2048 characters, on my local 5.7.7 server.

Please login to leave a reply, or register at first.