Alternate Collating Sequence - Database Property (Magic xpa 3.x)
Zoom from the Alternate Collating Sequence (ACS) setting to an Open File dialog box. Select the ACS file. The file name appears in the ACS Properties setting. Note that if no ACS file is specified in the ACS setting, Magic xpa will look for an ACS string in the Database Information setting. If no string is found, then Magic xpa will access the ACS file defined in the Alternate Collating Sequence File setting of the Environment dialog box.
The ACS file that appears in this setting reflects the ACS file set for the DBMS. When a new DBMS is selected for a specific database, the ACS file changes.
Once the connection to a database is created, it is only disconnected explicitly or by exiting Magic xpa (only exiting the application leaves the connection open). Therefore, the changes made in the database properties will take effect only in the next connection to the database. It is recommended to exit and re-launch Magic xpa whenever change database properties that affect Magic xpa gateway behavior.
For example, if your database is case insensitive and you want that the data from Magic xpa will be found regardless of the case, you can use the text below as the ACS file content. Simply copy it and save it to a file and define the file as the ACS file. Note that its best to get this information from the database (whenever possible), since for different languages you might need to use a different ACS file.