🚀 Welcome to MDriven Learn –  MDriven is now on Discord!  Don’t miss the latest Release Notes.
Parsed/Case sensitive or not
This page was created by PageReplicator on 2025-09-01. Last edited by PageReplicator on 2025-09-01.

Template:Notice



Tagged values[<a href="/index.php?title=Documentation:Case_sensitive_or_not&veaction=edit&section=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&section=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&section=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&section=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&section=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&section=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.