This property specifies order of collating the key field. The collation order is a comparison method to decide a big and small relation of the record.
Syntax
object.CollationOrder = integer
object
This specifies object expressions that define references to objects.
integer
This specifies order of collating the key field. For information about the values to set, refer to the following setting values.
Setting value
The setting values of the CollationOrder property are as follows.
Setting value | Meaning |
|---|---|
0 | No specification (order of collating of the system). (Default value) |
1 | Even if multiple byte characters coexist, each characters are compared. |
2 | The numbers that contains sign (+,-) characters are processed arithmetically. |
3 | The data that follows character strings, number are compared divided in character part and number part. |
Description
When this specification is omitted or 0 is set, the data are compared in the order of collating of the system. The sorting order of the records depends on the size of the character-codes.
When 1 is set, each character is compared even if characters that consist of multiple bytes exist.
When 2 is set, character strings in number that contain the signs are compared with arithmetic values. The data is not guaranteed when characters other than numbers exist in the character string.
When 3 is set, data in which alphabets are connected to numbers is compared separately for the alphabet and the numerical value. After only alphabets are compared, character strings with only numbers are compared by arithmetic values. It evaluates from the left of the specified field and the data that appeared after effective data is ignored.
The values specified in this property are effective when the key field is omitted in the sort processing (DisposalNumber = 0) or merge processing (DisposalNumber = 1) for the text file.
