[TYPO3-core] RFC: Trivial fix to stddb/tables.php

[Ernesto Baschny [cron IT]]

Martin Kutschker schrieb am 27.06.2006 22:28:

>> Type: Trivial
>> Branches: HEAD, TYPO3_4-0
>>
>> The attached patch changes a field type from char(2) to varchar(2), as
>> at least on my setup MySQL changes it to that anyway. Result is a
>> difference when comparing the database in the install tool.
> 
> Well, char(n) is defined - AFAIK in all DBs - to be exact n characters
> long (padded with spaces).
> 
> So it makes (in theory) a difference. Odd that Mysql reports a
> varchar(n) when we have a char(n) in the definition.


If you have a varchar in a table, all "char" in that table will be
silently transformed to a varchar by MySQL [1], so this fix is "+1" for
me too.

Cheers,
Ernesto

[1] http://dev.mysql.com/doc/refman/4.1/en/silent-column-changes.html