List of utf-8 and utf-16 sql collations

Question

Hi,

can anyone share the list of utf-8 and utf-16 collations avaliable in SQL server 2017 or 2019.

Thanks,
Monica

Answer 1

Try this code:

SELECT name, description FROM sys.fn_helpcollations();  

If you want to learn more about sql collations ,please refer to this document.

Bert Zhou

Answer 2

Hi @Monica K ,

Please refer to MS document Collation and Unicode support.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

can anyone share the list of utf-8 and utf-16 collations avaliable in SQL server 2017 or 2019.

The collation effects the way ASCII code is stored & interpreted = data type varchar. Therefore there can exists a UTF-8/16 collation.

Answer 4

All collations in SQL Server support UTF-16 - that is how the nvarchar data type is stored.

There is no support for UTF-8 in SQL 2017; those collations were added in SQL 2019.

For a full list of collations that supports UTF8 in SQL 2019, run

   SELECT * FROM sys.fn_helpcollations() WHERE name LIKE '%UTF8'  

There is only 1553 of them.