Support for ASCII Characters in Nondefault Code Sets (GLS)

Most code sets for nondefault locales (called nondefault code sets) support the ASCII characters. In a nondefault locale, the database server uses ASCII code-set order for ASCII data in CHAR and VARCHAR expressions, if the code set supports these ASCII characters. If the current collation (as specified by DB_LOCALE or by SET COLLATION) supports a localized collating order, however, that localized order is used when the database server sorts NCHAR or NVARCHAR values.