Progress
DataServer for
Microsoft SQL Server
Guide


Case Sensitivity

By default, a Progress database is case insensitive; however, you can set the attributes of a field to define it as either case sensitive or case insensitive. If you intend to do this, consider the following:

If an indexed field is case insensitive, Progress does not distinguish between uppercase and lowercase letters for that index when sorting or matching data. In general, this flexibility in an application makes data entry easier for end users because they can enter lowercase or uppercase versions of an index. However, if you want to enforce an uppercase/lowercase distinction in your applications, set the attribute to case sensitive.

If you are using a case sensitive page, the DataServer can make this feature compatible across Progress and MSS data sources. To support case insensitivity, an extra column must be added to the data source immediately before the indexed column. In most cases, this column is named _S#_column (exceptions are noted in the following sections). See the "Adding Extended 4GL Support" section in "The DataServer Tutorial," for instructions on adding this column automatically with the Progress-to-MSS utility.

NOTE: By default, sort order in SQL Server™ is not case sensitive.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095