Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Underscore character sorts after Ascii characters

With a basic sort sequence, some characters like underscore seem to sort after the other Ascii character 0-9,A-Z,a-z.

Windows sorts underscore characters before 0-9,A-Z,a-z.

CAUSE:

The sort sequence of the characters is defined in the collation table for the code page and collation being used. The underscore value has a higher sort weight than 0-9,A-Z,a-z.

FIX:

Create a collation table with the desired sort weights applied to each character. This process is described in the documentation.