Currently, the collation sequence for Microsoft Fabric SQL Database is set to SQL_Latin1_General_CP1_CI_AS, which means that creating tables or column names in Japanese or other languages will result in garbled characters.
We have also confirmed that it is currently not possible to change the collation sequence in Microsoft Fabric SQL Database.
On the other hand, the collation sequence for Microsoft Fabric warehouses is set to Latin1_General_100_BIN2_UTF8, which we have confirmed will not result in garbled characters.
Therefore, we believe that if we could change the collation sequence for Microsoft Fabric SQL Database, it would be possible to set it to Latin1_General_100_BIN2_UTF8, which would help prevent garbled characters.
akatesmith
on:
Include field parameters functionality in Azure An...
on:
Get rid of Microsoft sidebar in Power BI new works...
on:
Improve Bookmark Pane Usability: Persistent Menus,...
on:
Case Sensitivity ragrdless of the connection type ...
frithjof_v
on:
Lakehouse SQL Analytics Endpoint snapshots
on:
Power Query - Feature addition - To keep duplicat...