contao/newsletter-bundle

utf8mb4_bin usage

Closed this issue · 5 comments

As already mentioned in contao/comments-bundle#13 the newsletter-bundle for version 4.5.0 only required the core-bundle in version ^4.4. Thus the 4.5.0 version of this bundle is also automatically installed in Contao 4.4 installations (when using a default composer.json).

This has been fixed in 4279e57. However since there is already a 4.5.0 release of this bundle without this change, the 4.5.0 release will still be installed in Contao 4.4. This is a problem, since version 4.5.0 of this bundle uses utf8mb4_bin here - and proper utf8mb4 support (plus requirement checks) have only been added in Contao 4.5.0 (see also contao/comments-bundle#13 (comment)).

Not sure how this should be fixed though.

The only way to fix this is to remove the 4.5.0 tag of the comments, listing and newsletter bundles. I am going to do this as soon as I have tagged version 4.5.1.

Done.

Btw. why do all the alias fields use a hardcoded utf8mb4_bin collation now anyway? Even if you set

doctrine:
    dbal:
        connections:
            default:
                default_table_options:
                    charset: utf8
                    collate: utf8_unicode_ci

the collation of these fields would still be utf8mb4_bin.

A new issue thereto has been created at contao/core-bundle#1286.