- RDBMS Installation Considerations

The uniqueness of data can depend on character set and sort order applied to the database at the time of database installation. Once set up, this cannot be easily changed. The default sort (collation) order for databases may not be compatible with the standard order used by PROISAM; sorted records may display in a different order than expected. This difference can be a source of programming/data migration headaches if the PROIV database system is changed. Ensure that you understand the ramifications of the RDBMS installation options before creating databases.

A PROISAM-compatible collation sequence for SQL Server is BIN_850 with a CodeSet of 1250. A similar setting for DB2 is 'Identity'.

Comment on this topic

Topic ID: 720177