Fabric Data Warehouse - Case Sensitivity - More default collation options

[garddolau]

Hi Team,

Is there any plans to add more default collation options when creating a warehouse?

eg Latin1_General_100_CI_AS_SC_UTF8

For me collate Latin1_General_100_CI_AS_KS_WS_SC_UTF8 doesn't help with the main issue for case sensitivity on the data select.

eg When using SELECT with LIKE %% we still need to change collation which is pain and often gets forgotten leading to incorrect outputs.

eg still need to do this unfortunately 

SELECT *

FROM [warehouse].[dbo].[MyTable]

WHERE [MyColumn] LIKE '%SEARCH%' COLLATE Latin1_General_100_CI_AS_SC_UTF8;

Thanks,

Darren