Parse Collations in CREATE TABLE: Exception Handling or Ignoring

Why it matters

This feature addresses the need for better collation handling during table creation, improving error detection and user control. It helps users manage collation specifications explicitly, preventing silent misinterpretations or ignoring unsupported collations, thus enhancing table schema correctness and compatibility.

How to use it

When creating tables with CREATE TABLE, specify collations as part of the column definitions. ClickHouse will parse these collations and based on configuration or defaults, either throw an exception for unsupported collations or ignore them. No additional user action is required unless they want to handle errors explicitly.