UseSql92CompliantStringComparison Property

Determines whether String comparisons are performed according to the ANSI SQL92 specification. In particular, the ANSI standard requires padding for the character strings used in comparisons so that their lengths match before comparing them.

Syntax

Visual Basic
C#

'Declaration
 
<DataMemberAttribute()>
Public ReadOnly Property UseSql92CompliantStringComparison As Boolean

'Usage
 
Dim instance As CacheQueryOptions
Dim value As Boolean
 
value = instance.UseSql92CompliantStringComparison

[DataMember()]
public bool UseSql92CompliantStringComparison {get;}

Remarks

Note that this is typically NOT enforced for operations that rely on the SQL 'Like' operator such as 'StartsWith' 'EndsWith' and 'Contains'. So, for example: "ABC" == "ABC " -> true but "ABC".StartsWith("ABC ") -> false

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CacheQueryOptions Class
CacheQueryOptions Members