Project

General

Profile

Actions

Bug #16276

closed

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

Added by Bernd Hanisch over 18 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2006-06-23
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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)


Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #14742: Install - Databanalyser - CompareClosedMichael Stucki2005-05-18

Actions
Related to TYPO3 Core - Bug #17243: Install tool's DB compare shows wrong tables to update on MySQL 5 collation latin1_binClosed2007-04-25

Actions
Related to TYPO3 Core - Bug #23465: db compare in install tool and ext-manager reports no-op changes e.g. for int columnsClosed2010-08-27

Actions
Actions

Also available in: Atom PDF