[TYPO3-dev] TYPO3 4.0.3

[Felix Griesser]

ben van 't ende [netcreators] schrieb:
> Hi,
>
> With a database COMPARE in the install tool I still get this error in 
> all if not all TYPO3 installs:
>
> Changing fields
> 	ALTER TABLE be_users CHANGE lang lang varchar(2) NOT NULL default '';
> 	Current value: char(2) default ''
>
> Can this be fixed for 4.0.3?
>
> gRTz
>
> ben
>   
Hi
the column should be "char" not "varchar", as the MySQL manual says - it 
does a silent column specification change if...

    * "|VARCHAR| columns with a length less than four are changed to
      |CHAR|."

please refer here:
for 4.1   http://dev.mysql.com/doc/refman/4.1/en/silent-column-changes.html
for 5.0   http://dev.mysql.com/doc/refman/5.0/en/silent-column-changes.html

What me confuses a little bit - the bug report 3885 has a resolution 
flag "Won't fix" and Michael Stucki says it's a bug of mysql. But it's 
not a bug, right? It's by design...
Why should the be_users.lang column be a varchar-type? Maybe because of 
depracted (longer...) values as "lang.de", "lang.dk", "lang.no",  
"lang.en" etc? Or maybe it has to do with compatibility reasons for 
mysql versions < 4.0?

greetings...