Issue Bug Closed

#107092Collation check fails for sys_refindex.hash column despite correct ascii_bin collation

Markus Guger 07/14/25, 12:40 updated 07/14/25, 14:53

Description

TYPO3 13.4.15 shows collation warning for sys_refindex.hash column

Problem:
- TYPO3 13.4.x documentation states that sys_refindex.hash should use ascii_bin collation
- TYPO3’s collation check complains about mixed collations when hash column uses ascii_bin
- This creates a contradiction: TYPO3 expects ascii_bin but rejects it

Steps to reproduce:
1. Install TYPO3 13.4.15
2. Create sys_refindex table with hash column using ascii_bin collation
3. Run database analyzer
4. Warning appears: “Tabellen mit anderen Kollationen gefunden”

Expected behavior:
- Either accept ascii_bin for hash column
- Or update documentation to use utf8mb4_unicode_ci

This is a fundamental contradiction in TYPO3 13.4.x requirements.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.