Antwort #2 am: 11. Januar 2015, 19:33:44
Hallo,
Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.
Da ich Mysql 5.5 verwende ich ich mein varchar auf 1020 geändert.
Betroffen ist diese Tabelle
CREATE TABLE configuration (
configuration_id INT NOT NULL AUTO_INCREMENT,
configuration_key VARCHAR(64) NOT NULL,
configuration_value VARCHAR(255) NOT NULL,
configuration_group_id INT NOT NULL,
sort_order INT(5) NULL,
last_modified DATETIME NULL,
date_added DATETIME NOT NULL,
use_function VARCHAR(255) NULL,
set_function VARCHAR(255) NULL,
PRIMARY KEY (configuration_id),
KEY idx_configuration_group_id (configuration_group_id)
) ENGINE=MyISAM;
Gruß
James