Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Database design issues : Interaction of code page, collation, and case sensitivity
 

Interaction of code page, collation, and case sensitivity

Properly setting code page, collation, and case sensitivity values such that they compliment each other, will yield the best scenarios for data access. To avoid conflict between code page, collation, and case sensitivity, set these characteristics at schema creation, and allow a schema pull to manage the DataServer integration. If any of these settings are changed, the schema holder should be regenerated. Table  describes the interaction between code page, collation, and case sensitivity.