Etsuo Hayama (Japan Concentrix KK) on 09 Dec 2024 05:46:10
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.
Administrator
This is a known issue that we intend to fix .
Thanks
- Comments (1)
RE: How to deal with garbled characters in Microsoft Fabric SQL Database
This is critical for international adoption. In spite of what we may think, the world is full of languages other than American.