Collations

The first major addition is the fact that both memory-optimized tables and natively compiled stored procedures support all code pages and collations that SQL Server supports. The previous limitation of only a supporting a subset of collations otherwise available in SQL Server has been completely removed from the product (a newly supported collation has been used in the test table in the demo scripts in this chapter)

This improvement allows us to incorporate tables and stored procedures using the collations that we are used to, or have already used in our database designs.

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.