IdeaBlade DevForce 2010 Help Reference
UseSql92CompliantStringComparison Property
See Also  Send Feedback
IdeaBlade.EntityModel Assembly > IdeaBlade.EntityModel Namespace > CacheQueryOptions Class : 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 (Declaration) 
<DataMemberAttribute()>
Public ReadOnly Property UseSql92CompliantStringComparison As Boolean
Visual Basic (Usage)Copy Code
Dim instance As CacheQueryOptions
Dim value As Boolean
 
value = instance.UseSql92CompliantStringComparison
C# 
[DataMemberAttribute()]
public bool UseSql92CompliantStringComparison {get;}
C++/CLI 
[DataMemberAttribute()]
public:
property bool UseSql92CompliantStringComparison {
   bool 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2013 All Rights Reserved.