International

Examples

This setting allows a Dexterity application to use an alternate collating sequence. This is useful when an application developed in one language is being converted for use in another language that uses a different character set.

Syntax

International = option

Parameters

• option - A boolean that indicates whether the International setting is activated:

[spacer]

Value

Description

TRUE

Specifies that the application will use the alternate collating sequence.

FALSE

Specifies that the application will use the standard ASCII collating sequence. False is the default value.

Comments

This setting allows an application to use the collating sequence specified in a text file named DEX.ACS, located in the same directory as the DEX.DIC file. The layout of the DEX.ACS file is as follows:

In the collating sequence, each character’s position in the binary sequence is assigned a two-character hexidecimal value specifying its sorting “weight.” Characters assigned lower weights will precede those with higher weights in the sort sequence. You can assign multiple characters the same sorting weight. For example, you may wish all the accented versions of the lowercase e to sort without regard to their accent. The first and last positions in the sequence must be assigned the values 00 and FF, respectively.

For case-sensitive sorts, uppercase letters should be assigned lower values than lowercase letters. For example, the letters A through Z occupy positions 65 through 90 (hexadecimal 41 through 5A) in a standard ASCII sequence, while the letters a through z occupy positions 97 through 121 (hexadecimal 61 through 79). For case-insensitive sorts, the value assigned to each uppercase letter should be the same as that assigned to its lowercase equivalent.

The following is a sample DEX.ACS file:

EXTEND
00,01,02,03,04,05,06,07,08,09,0A,0B,0C,0D,0E,0F,
10,11,12,13,14,15,16,17,18,19,1A,1B,1C,1D,1E,1F,
20,21,22,23,24,25,26,27,28,29,2A,2B,2C,2D,2E,2F,
30,31,32,33,34,35,36,37,38,39,3A,3B,3C,3D,3E,3F,
40,41,43,44,46,47,49,4A,4B,4C,4D,4E,4F,51,52,54,
56,57,58,59,5B,5C,5D,5E,5F,60,61,64,65,66,67,68,
69,6A,6C,6D,6F,70,72,73,74,75,76,77,78,7A,7B,7D,
7F,80,81,82,84,85,86,87,88,89,8A,8D,8E,8F,90,91,
92,93,94,95,96,97,98,99,9A,9B,9C,9D,5A,9E,9F,62,
A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,AA,AB,83,AC,AD,8B,
AE,AF,B0,50,B1,42,B2,B3,B4,B5,B6,B7,B8,B9,BA,63,
BB,BC,BD,79,BE,BF,C0,C1,C2,6B,C3,C4,C5,C6,C7,8C,
C8,C9,CA,CB,CC,CD,45,CE,CF,D0,48,D1,D2,D3,D4,D5,
D6,53,D7,55,D8,D9,DA,DB,DC,DD,DE,DF,E0,E1,E2,E3,
E4,E5,E6,E7,E8,E9,6E,EA,EB,EC,71,ED,EE,EF,F0,F1,
F2,7C,F3,7E,F4,F5,F6,F7,F8,F9,FA,FB,FC,FD,FE,FF
EXTENDU
00,01,02,03,04,05,06,07,08,09,0A,0B,0C,0D,0E,0F,
10,11,12,13,14,15,16,17,18,19,1A,1B,1C,1D,1E,1F,
20,21,22,23,24,25,26,27,28,29,2A,2B,2C,2D,2E,2F,
30,31,32,33,34,35,36,37,38,39,3A,3B,3C,3D,3E,3F,
40,41,43,44,46,47,49,4A,4B,4C,4D,4E,4F,51,52,54,
56,57,58,59,5B,5C,5D,5E,5F,60,61,64,65,66,67,68,
69,41,43,44,46,47,49,4A,4B,4C,4D,4E,4F,51,52,54,
56,57,58,59,5B,5C,5D,5E,5F,60,61,6A,6B,6C,6D,6E,
6F,70,71,72,73,74,75,76,77,78,79,7A,5A,7B,7C,62,
7D,7E,7F,80,81,82,83,84,85,86,87,88,5A,89,8A,62,
8B,8C,8D,50,8E,42,8F,90,91,92,93,94,95,96,97,63,
98,99,9A,50,9B,9C,9D,9E,9F,42,A0,A1,A2,A3,A4,63,
A5,A6,A7,A8,A9,AA,45,AB,AC,AD,48,AE,AF,B0,B1,B2,
B3,53,B4,55,B5,B6,B7,B8,42,BA,BB,BC,BD,BE,BF,C0,
C1,C2,C3,C4,C5,C6,45,C7,C8,C9,48,CA,CB,CC,CD,CE,
CF,53,D0,55,D1,D2,D3,D4,D5,D6,D7,D8,D9,DA,DB,FF

When this setting is activated, any new tables that are created will use the alternate collating sequence. Existing tables must be shrunk to enable the alternate collating sequence.

This setting has no effect when a SQL database type is used.

Documentation Feedback