Reply to thread

Message

[code]ALTER TABLE mptvdb.<tablename> ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code]
worked without any warnings

Except these ones:
ALTER TABLE mptvdb.schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE mptvdb.recording ENGINE=InnoDB ROW_FORMAT=COMPACT;

They gave the following error:
[code]0 22 08:19:57 ALTER TABLE mptvdb.schedule ENGINE=InnoDB ROW_FORMAT=COMPACT Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.016 sec[/code]

The keyvalue is to long for the chosen character-set "utf8-default collation" .

So the key or the character-set has to be changed.
Does anyone has an idea which character-set should be used?

<blockquote data-quote="megahorst" data-source="post: 967310" data-attributes="member: 22213">[code]ALTER TABLE mptvdb.&lt;tablename&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code]worked without any warnings&nbsp;Except these ones:ALTER TABLE mptvdb.schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE mptvdb.recording&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;&nbsp;They gave the following error:[code]0&nbsp; &nbsp; 22&nbsp; &nbsp; 08:19:57&nbsp; &nbsp; ALTER TABLE mptvdb.schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT&nbsp; &nbsp; Error Code: 1071. Specified key was too long; max key length is 767 bytes&nbsp; &nbsp; 0.016 sec[/code]&nbsp;The keyvalue is to long for the chosen character-set &quot;utf8-default collation&quot; .&nbsp;So the key or the character-set has to be changed.Does anyone has an idea which character-set should be used?</blockquote>

[QUOTE="megahorst, post: 967310, member: 22213"] [code]ALTER TABLE mptvdb.<tablename> ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code] worked without any warnings Except these ones: ALTER TABLE mptvdb.schedule ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE mptvdb.recording ENGINE=InnoDB ROW_FORMAT=COMPACT; They gave the following error: [code]0 22 08:19:57 ALTER TABLE mptvdb.schedule ENGINE=InnoDB ROW_FORMAT=COMPACT Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.016 sec[/code] The keyvalue is to long for the chosen character-set "utf8-default collation" . So the key or the character-set has to be changed. Does anyone has an idea which character-set should be used? [/QUOTE]