Mapping to code page (SQL Server)

How to determine which codepage a particular collation uses on SQL Server?

+4
source share
1 answer

The COLLATIONPROPERTY function can be used to get a code page. Here is the code page for all possible mappings:

 SELECT [Name], [Description], [CodePage] = COLLATIONPROPERTY([Name], 'CodePage') FROM ::fn_helpcollations() 
+5
source

Source: https://habr.com/ru/post/1400262/


All Articles