Home
IBM Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Lotus® Connectors
Lotus® Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
LSX for Lotus® Connectors
LotusScrip Extensions for Lotus® Connectors (LC LSX) enhances the power of Notes® by extending its scripting to data outside of Notes through the use of Lotus Connectors. The programming model is independent of the individual connector. This eliminates the need to learn each individual system, while at the same time allowing experienced users to access the individual features of a specific system.
Appendix D Character Sets
This appendix provides information about character sets, including character set translation, character sort order, and a list of the character sets supported by the Lotus® Connector LotusScript® Extensions (LC LSX).
Character Sort Order in LEI
IBM® Lotus Enterprise Integrator® (LEI) cannot control the sort order specified in the databases that it accesses. If the sort orders used in two databases are not the same, mismatches can arise during Replication activities, causing excessive insert/delete operations and thereby affecting performance. The use of the Order MetaConnector for databases which sort differently is designed to solve sort order differences. Replication also provides an option for case-insensitive string comparison when excessive insert/delete pairs occur during replication between databases that use case-insensitive sorting.

Character Sort Order in LEI

IBM® Lotus Enterprise Integrator® (LEI) cannot control the sort order specified in the databases that it accesses. If the sort orders used in two databases are not the same, mismatches can arise during Replication activities, causing excessive insert/delete operations and thereby affecting performance. The use of the Order MetaConnector for databases which sort differently is designed to solve sort order differences. Replication also provides an option for case-insensitive string comparison when excessive insert/delete pairs occur during replication between databases that use case-insensitive sorting.

See the Replication activity chapter of the Lotus Enterprise Integrator® Activities and User Guide for more information about this feature. Also see the Lotus® Connectors and Connectivity Guide for information about the Lotus® Connectors and Metaconnectors.