Collate Clause Support in Warehouse
Data Warehouse · General availability · Shipped
Description
This feature enables users to specify collations on individual columns, rather than relying solely on the artifact-level collation. Users will be able to use the 'COLLATE' command with the CREATE Table / ALTER Table ADD Nullable colum / SELECT INTO / CTAS statements to define the collation for their VARCHAR / CHAR fields. This release also includes support for the 'DATABASE_DEFAULT' collation. All Fabric warehouses by default are configured with case-sensitive (CS) collation Latin1_General_100_BIN2_UTF8. You can also create warehouses with case-insensitive (CI) collation - Latin1_General_100_CI_AS_KS_WS_SC_UTF8
Change History
-
2025-02-25
Roadmap Item Added
Workload: Data Warehouse