Enhanced collations

text

Signed

expressions: text

Signed

expressions: text

The Database Engine supports character and Unicode string constants that support enhanced collations. For more information, see the COLLATE clause.

Data types (Transact-SQL)

Expressions (Transact-SQL)

Operators (Transact-SQL)

Collation and Unicode support

Collation precedence

smallint

int

smallint

int

+145345234.2234
-2147483648.10
+123E-3
-12E5
-$45.56
+$423456.99