TYPO3 Core

In short: one *.sql file of the source distribution should be replaced by the one supplied here.

Version typo3_src-4.1.2 comes with fifteen *.sql files. Thirteen are all ASCII which is fine. "typo3_src-4.1.2/typo3/sysext/tsconfig_help/ext_tables_static+adt.sql" has UTF-8 encoding which can be considered fine as well.

./typo3/sysext/cms/ext_tables_static+adt.sql is partly Latin-1 with Unicode U+FFFD REPLACEMENT CHARATER encoded as UTF-8 at six places. This is partly wrong and partly inconsistent. It will not really create problems for anyone. But it wipes out a litlle bit of history (which I don't cling to).

More important: It may be very misleading to those having trouble with their database and looking for corrupted data. They might take the replaced characters in this file as indicatior that character conversion at some point in their installation goes wrong. Not knowing the mistakes are in the source file already ...

The whole thing here is just a side effect of trying to understand why there were problems with the UTF-8 stuff in my installation und how I can convert older installations. But now that I've invested that much time I bring this to an end and supply the fully corrected version. The file is already wrong in typo3_src.3.8.1. I grabbed an old 3.3.0 version and as step 1 changed six latin-1 lines from wrong to right:

frit tilg�ngeligt fra
frit tilgængeligt fra

header = Standard Template "GL�CK"
header = Standard Template "GLÜCK"

header = MENU, "GL�CK"
header = MENU, "GLÜCK"

header = MENU2, "GL�CK"
header = MENU2, "GLÜCK"

header = RIGHT COLUMN, "GL�CK"
header = RIGHT COLUMN, "GLÜCK"

header = MENU COLUMN, "GL�CK"
header = MENU COLUMN, "GLÜCK"

After this there are only Latin-1 character left. As step 2 I converted the file to UFT-8. This corrected version is appended here.
(issue imported from #M6177)