<< Click to Display Table of Contents >> Navigation:  Apollo VCL Components > Installing and Using Apollo VCL > Collation Support Summary

The following explains the various ways to use and implement the new collation and internationalization support provided by Apollo.

Also, see the new collation sample here: ..\Engine\Collation

Collation and TApolloQuery

The sections listed below apply to TApolloTable only. To configure collation settings with TApolloQuery, call the corresponding ApolloEngine methods that are listed below directly from TApolloQuery. Do not call ApolloEngine nor add ApolloEngInt to your units, since ApolloEngine affects TApolloTable only. For example, do the following to add MachineCollation to an ApolloQuery object (TApolloQuery):

 

// instead of ApolloEngine.SetMachineCollation

ApolloQuery1.SetMachineCollation;

Collation and TApolloTable

The following sction lists all the various collation settings that can be used by TApolloTable.

Simultaneous DOS and Windows Support

DOS (Non-International) with Apollo

 

1.Add ApolloEngInt to the uses of your main form

2.Call ApolloEngine.SetMachineCollation once in initialization routine

 

-OR-

1.For each table and query, set OEMTranslate := True;

2.In ApolloEngInt.PAS, uncomment the following line and recompile the Apollo package:
// {$define INTL_LANG}

DOS (International) with Apollo

1.For each table and query, set OEMTranslate := True;

2.See the OEMSORT.TXT file located in \DOCS directory and "cut" out the
required collation section and place into your application.

DOS (German using Duden collation) with Apollo

1.For each table and query, set OEMTranslate := True;

2.Add ApolloEngInt to the uses of your main form

3.Call ApolloEngine.AddDudenCollation;

4.Open the OEMSORT.TXT file located in \DOCS directory and copy and paste the
required collation section and place into your application.

If the Windows System settings are already German (i.e. Duden is supported by default) then you can do the following instead (basically omit step 4):

1.For each table and query, set OEMTranslate := True;

2.Add ApolloEngInt to the uses of your main form

3.Call ApolloEngine.AddDudenCollation;

Windows ONLY with Apollo

Apollo using International Settings

(Simple linguistic alphabet collation 'letter by letter')

Nothing required. Just make sure the proper language is set in the Windows system settings.

Apollo using German DUDEN collation

1.Add ApolloEngInt to the uses section of the main form

2.Call ApolloEngine.AddDudenCollation;

-OR-

1.Make sure the correct language is set in Windows system settings.

2.In ApolloEngInt.PAS, uncomment the following line and recompile the Apollo package:
// {$define DUDN_LANG}

Apollo using Spanish

 

1.Add ApolloEngInt to the uses section of the main form

2.Call ApolloEngine. AddEtecCollation;

3.

-OR-

 

1.Make sure proper language is set in Windows system settings.

2.In ApolloEngInt.PAS, uncomment the following line and recompile the Apollo package:
// {$define SPAN_LANG}

Apollo using DOS-like collation for English (Machine Collation)

 

1.Add ApolloEngInt to the uses section of the main form

2.Call ApolloEngine. SetMachineCollation;

-OR-

 

1.In ApolloEngInt.PAS, uncomment the following line and recompile the Apollo package:
// {$define INTL_LANG}

 

See Also

Sort Order , TApolloEngine