[TYPO3-core] RFC: performance improvemenets for database

[Wolfgang Klinger]

*hiya!*

Dmitry Dulepov wrote:
> - be_users.lang is defined as varchar(2), which always becomes char(2)
> in mysql. Here is what mysql manual says: "MySQL may silently change the
> type of a CHAR  or VARCHAR column at table creation time" [2] and
> "VARCHAR columns with a length less than four are changed to CHAR" [1].
> And about "CHAR" type: "When CHAR  values are stored, they are
> right-padded with spaces to the specified length. When CHAR values are
> retrieved, trailing spaces are removed." [2] To avoid never disappearing
> warning in COMPARE, we need to change that column as well.

+1


bye
Wolfgang