Issue Bug Closed

#16276Database Analyser - Compare proposes "ALTER ..... NOT NULL" again and again

Bernd Hanisch 06/23/06, 15:34 updated 05/22/14, 14:35

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.