Skip to content

Commit 2289536

Browse files
authored
Update collation-and-unicode-support.md
1 parent 7fdd691 commit 2289536

1 file changed

Lines changed: 2 additions & 5 deletions

File tree

docs/relational-databases/collations/collation-and-unicode-support.md

Lines changed: 2 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -473,16 +473,13 @@ To use the UTF-8 collations that are available in [!INCLUDE[sql-server-2019](../
473473

474474
- The UTF8 flag can be applied to:
475475
- Linguistic collations that already support supplementary characters (\_SC) or variation-selector-sensitive (\_VSS) awareness
476-
- BIN2<sup>1</sup> binary collation
476+
- BIN2 binary collation
477477

478478
- The UTF8 flag can't be applied to:
479479
- Linguistic collations that don't support supplementary characters (\_SC) or variation-selector-sensitive (\_VSS) awareness
480-
- The BIN or BIN2<sup>2</sup> binary collations
480+
- The BIN binary collations
481481
- The SQL\_* collations
482482

483-
<sup>1</sup> Starting with [!INCLUDE[sql-server-2019](../../includes/sssql19-md.md)] CTP 2.3. [!INCLUDE[sql-server-2019](../../includes/sssql19-md.md)] CTP 3.0 replaced collation **UTF8_BIN2** with **Latin1_General_100_BIN2_UTF8**.
484-
<sup>2</sup> Up to with [!INCLUDE[sql-server-2019](../../includes/sssql19-md.md)] CTP 2.3.
485-
486483
To evaluate issues that are related to using Unicode or non-Unicode data types, test your scenario to measure performance differences in your environment. It's a good practice to standardize the collation that's used on systems across your organization, and to deploy Unicode servers and clients wherever possible.
487484

488485
In many situations, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] interacts with other servers or clients, and your organization might use multiple data-access standards between applications and server instances. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] clients are one of two main types:

0 commit comments

Comments
 (0)