{"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":"Using the public REST APIs to create a Data Warehouse includes a new option to set the default collation.  This can be used to set a new Case Insensitive Collation default. The two supported collations are Latin1_General_100_CI_AS_KS_WS_SC_UTF8 (which is Case Insensitive) and Latin1_General_100_BIN2_UTF8 (which is Case Sensitive) and continues to be our default. COLLATE T-SQL clause support is coming soon. This will enable you to utilize the COLLATE command with CREATE or ALTER TABLE to directly specify the collation for your VARCHAR fields.","feature_name":"Case insensitive collation support (Warehouse only)","last_modified":"2026-06-16","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"Q4 2024","release_item_id":"d088dc22-d1fa-ee11-a1ff-000d3a340b2c","release_status":"Shipped","release_type":"General availability"}