{"active":true,"blog_title":"Streamlining Data Management with Workspace Collation Settings in Microsoft Fabric Warehouse and SQL Endpoint","blog_url":"https://community.fabric.microsoft.com/blog/fbc_fabricupdatesblogs/streamlining-data-management-with-workspace-collation-settings-in-microsoft-fabr/5172641","feature_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","feature_name":"Collate Clause Support in Warehouse","last_modified":"2026-06-16","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"Q1 2025","release_item_id":"1eb2c309-13e0-ef11-a730-6045bd077c18","release_status":"Shipped","release_type":"General availability"}