sys.sp_helpsort

Description

Displays the sort order and character set for the instance of SQL Server. Returns server default collation. If an instance of SQL Server is installed with a collation specified to be compatible with an earlier installation of SQL Server, returns blank results.

Syntax

SELECT
SERVERPROPERTY ('Collation');

Permissions

Examples

Example 1

EXECUTE sp_helpsort;
Server default collation
------------------------
Latin1-General , case-sensitive , accent-sensitive , kanatype-insensitive , width-
insensitive for Unicode Data , SQL Server Sort Order 51 on Code Page 1252 for non-
Unicode Data.