String and binary types

Type

Analytics Platform System (PDW)

SQL analytics endpoint in

Microsoft Fabric

Warehouse in Microsoft Fabric

supports the following string and binary types.

Description

varbinary

Binary data types of either fixed length or variable length.

and

data is the easiest way to move around data.

varchar

Character data types that are either fixed-size,

, or variable-size,.

types store the full range of Unicode character data and use the UTF-8 character

encoding.

nvarchar

Unicode character data types that are either fixed-size,

, or variable-size,.

Starting with SQL Server 2012 (11.x), when a Supplementary Character (SC) enabled

the UTF-16 character encoding.

ntext, text,

Fixed and variable-length data types for storing large non-Unicode and Unicode

character and binary data. Unicode data uses the Unicode UCS-2 character set.

The

,

data types will be removed in a future version of SQL Server.

Avoid using these data types in new development work, and plan to modify applications

that currently use them.

Data types (Transact-SQL)

String Functions