skip to main content
OpenEdge Data Management: DataServer for ODBC
Programming Considerations : Database design issues
 

Database design issues

When you create or modify the OpenEdge databases or ODBC data sources that your applications access, you must consider general database design issues such as OpenEdge and ODBC data-source objects, data types, naming conventions, code pages, and indexes. The following sections discuss how OpenEdge databases and ODBC data sources differ in such areas and describe how the DataServer resolves them.
In this section: 
* OpenEdge database objects and ODBC data-source objects
* Naming conventions
* ODBC data source limits
* Code pages
* Indexes and sorting
* Case sensitivity
* Interaction of code page, collation, and case sensitivity
* ODBC data-source views
* Triggers
* OpenEdge sequences
* Processing considerations for 32-bit and 64-bit data types
* User-defined data types
* Arrays
* Unknown values
* Zero-length character strings