Blog-Archive

MySQL: Change collation for all tables in your database

Did you ever had a problem that the special characters are not correctly displayed on your front end? Like you see M?nchen instead of München? This error can happen if your database or table or column has a different character-set

Getagged mit: , ,
Veröffentlicht unter Database, TYPO3 Technik

Detect duplicated references in the database (Related to the bug 66920)

We have found recently a small but very annoying bug (https://forge.typo3.org/issues/66920), which results some inconsistent records in the database. As in the bug report described, it can happen wit any instance without any extension, and also inside any extension like

Getagged mit: , , , ,
Veröffentlicht unter Database, TYPO3 Allgemein, TYPO3 Technik

Delete duplicate records from MM tables

If somehow (f.e. because of a migration from DAM to FAL) you face with duplicate records in MM table you need a small trick to be able to delete them.

Getagged mit: , , ,
Veröffentlicht unter Database, TYPO3 Technik