Bug #16276
closedDatabase Analyser - Compare proposes "ALTER ..... NOT NULL" again and again
0%
Description
ALTER TABLE be_users CHANGE lang lang char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE tx_dam CHANGE language language char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE tx_dam CHANGE loc_country loc_country char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE tx_dam CHANGE height_unit height_unit char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_countries CHANGE cn_iso_2 cn_iso_2 char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_countries CHANGE cn_iso_3 cn_iso_3 char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_countries CHANGE cn_tldomain cn_tldomain char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_countries CHANGE cn_currency_iso_3 cn_currency_iso_3 char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_country_zones CHANGE zn_country_iso_2 zn_country_iso_2 char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_country_zones CHANGE zn_country_iso_3 zn_country_iso_3 char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_currencies CHANGE cu_iso_3 cu_iso_3 char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_languages CHANGE lg_iso_2 lg_iso_2 char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_languages CHANGE lg_typo3 lg_typo3 char(2) NOT NULL default '';
Current value: varchar(2) default ''
that happen, if u have your typo3-installation configured for utf8 support (also the mysql-database)
[SYS][setDBinit] = SET names 'utf8';
any suggestions how to fix this?
(issue imported from #M3728)