Tagged values[<a href="/index.php?title=Documentation:Case_sensitive_or_not&veaction=edit§ion=1" class="mw-editsection-visualeditor" title="Edit section: Tagged values" data-bs-title="Documentation:Case_sensitive_or_not">edit</a> | <a href="/index.php?title=Documentation:Case_sensitive_or_not&action=edit§ion=1" title="Edit section: Tagged values" data-bs-title="Documentation:Case_sensitive_or_not">edit source</a>]
When it comes to tagged values, the value is a string. It is up to the implementer how the interpretation is done -> case-to-case. Having said that, we aim to have all boolean-tagged values as case insensitive. If you find exceptions to this ambition, it would be great if you reported it so that we can fix it.
OCL[<a href="/index.php?title=Documentation:Case_sensitive_or_not&veaction=edit§ion=2" class="mw-editsection-visualeditor" title="Edit section: OCL" data-bs-title="Documentation:Case_sensitive_or_not">edit</a> | <a href="/index.php?title=Documentation:Case_sensitive_or_not&action=edit§ion=2" title="Edit section: OCL" data-bs-title="Documentation:Case_sensitive_or_not">edit source</a>]
OCL is largely case-insensitive when it comes to identifiers and operators BUT types must start with a Capital-letter. Data in MDriven is always case sensitive; operators <a href="/Documentation:OCLOperators_ToUpper_()_:_String" title="Documentation:OCLOperators ToUpper () : String" data-bs-title="Documentation:OCLOperators_ToUpper_()_:_String">toupper</a>, <a href="/Documentation:OCLOperators_ToLower_()_:_String" title="Documentation:OCLOperators ToLower () : String" data-bs-title="Documentation:OCLOperators_ToLower_()_:_String">tolower</a>, <a href="/Documentation:OCLOperators_sqlLike" title="Documentation:OCLOperators sqlLike" data-bs-title="Documentation:OCLOperators_sqlLike">sqllike</a> and <a href="/Documentation:OCLOperators_sqlLikeCaseInsensitive" title="Documentation:OCLOperators sqlLikeCaseInsensitive" data-bs-title="Documentation:OCLOperators_sqlLikeCaseInsensitive">sqllikecaseinsensitive</a> handle case conversion.
OCL-PS / Database[<a href="/index.php?title=Documentation:Case_sensitive_or_not&veaction=edit§ion=3" class="mw-editsection-visualeditor" title="Edit section: OCL-PS / Database" data-bs-title="Documentation:Case_sensitive_or_not">edit</a> | <a href="/index.php?title=Documentation:Case_sensitive_or_not&action=edit§ion=3" title="Edit section: OCL-PS / Database" data-bs-title="Documentation:Case_sensitive_or_not">edit source</a>]
When creating SQL-Server instances, you can decide what collation to use. Collations containing "_CI_"
in the name are case insensitive while others are case sensitive. We offer OCL operators <a href="/Documentation:OCLOperators_sqlLike" title="Documentation:OCLOperators sqlLike" data-bs-title="Documentation:OCLOperators_sqlLike">sqllike</a> and <a href="/Documentation:OCLOperators_sqlLikeCaseInsensitive" title="Documentation:OCLOperators sqlLikeCaseInsensitive" data-bs-title="Documentation:OCLOperators_sqlLikeCaseInsensitive">sqllikecaseinsensitive</a>.
In the persistence mapping setup for MDrivenServer, we use a bit to represent bool in the database -> 1==true
, 0==false
. If you have DefaultDbValue on a boolean, you must put 1 or 0.