sql将排序的最大字段长度是多少？对于varchar或nvarchar

Hey guys I thought I ran into something where sql would only sort up to a certain length of a varchar or nvarchar. Does anyone know that #?Hey guys I thought I ran into something where s