prop_servercaseinsensitive.htm
| Navigation: SQL Driver Properties(General) >====== PROP:ServerCaseInsensitive ====== |    |
The SQL drivers 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 use UPPER for all SQL sent to the backend.
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 all UPPER CASE.
prop_servercaseinsensitive.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1