"collate" is deprecated in Doctrine

[ameotoko]

Affected version(s)

4.13

Description

Looks like collate here should become collation now? 🤔

contao/manager-bundle/src/Resources/skeleton/config/config.yml

Lines 45 to 58 in 751a4a8

	# Doctrine configuration
	doctrine:
	dbal:
	default_connection: default
	connections:
	default:
	driver: pdo_mysql
	url: '%env(DATABASE_URL)%'
	charset: utf8mb4
	default_table_options:
	charset: utf8mb4
	collate: utf8mb4_unicode_ci
	engine: InnoDB
	row_format: DYNAMIC

Reference:

• Contao 4.13 -> Installtool -> DB aktualisieren -> statement ALTER TABLE tl_member funktioniert nicht terminal42/contao-mailusername#20
• Mysql comparator breaks with table options collate doctrine/dbal#5265
• Configuration for collation in default table options (collate/collation) doctrine/DoctrineBundle#1468
• Deprecate "collate" default table option doctrine/DoctrineBundle#1478

[leofeyer]

@ameotoko Can you please check if the changes from #4592 fix your issue?

[ameotoko]

Yes they do, thank you @leofeyer