PROP:ServerCaseInsensitive

Top  Previous  Next

In previous versions of Clarion, the SQL file drivers assumed that your SQL server was set up to support case sensitive searches. This required a modification of all case insensitive keys defined in the data dictionary to achieve optimum performance.

The SQL drivers now assume that the server is set up with case insensitive searches, and no longer generate UPPER calls in the SQL code when requested by the Clarion code. To turn off this behavior (force generation of UPPER calls), use PROP:ServerCaseInsensitive. When this file property is active (1), you will make the file driver behave as in previous versions (prior to 6.3).

This property only needs to be set once per connection and can only be done after a connection to the database has been established

Example:

Customer{PROP:ServerCaseInsensitive} = 1

!server searches are now case insensitive.