(Automatically adding template at the end of the page.) |
No edit summary |
||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
<message>Write the content here to display this box</message> | |||
==== Tagged values ==== | ==== Tagged values ==== | ||
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. | 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 ==== | ==== OCL ==== | ||
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 [[OCLOperators ToUpper () : String|toupper]], [[OCLOperators ToLower () : String|tolower]], [[OCLOperators sqlLike|sqllike]] and [[OCLOperators sqlLikeCaseInsensitive|sqllikecaseinsensitive]] handle case conversion. | 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 [[Documentation:OCLOperators ToUpper () : String|toupper]], [[Documentation:OCLOperators ToLower () : String|tolower]], [[Documentation:OCLOperators sqlLike|sqllike]] and [[Documentation:OCLOperators sqlLikeCaseInsensitive|sqllikecaseinsensitive]] handle case conversion. | ||
==== OCL-PS / Database ==== | ==== OCL-PS / Database ==== | ||
When creating SQL-Server instances, you can decide what collation to use. Collations containing <code>"_CI_"</code> in the name are case insensitive while others are case sensitive. We offer OCL operators [[OCLOperators sqlLike|sqllike]] and [[OCLOperators sqlLikeCaseInsensitive|sqllikecaseinsensitive]]. | When creating SQL-Server instances, you can decide what collation to use. Collations containing <code><span class="col-black">'''"_CI_"'''</span></code> in the name are case insensitive while others are case sensitive. We offer OCL operators [[Documentation:OCLOperators sqlLike|sqllike]] and [[Documentation:OCLOperators sqlLikeCaseInsensitive|sqllikecaseinsensitive]]. | ||
In the persistence mapping setup for MDrivenServer, we use a bit to represent bool in the database -> <code><span class="col-black">'''1==true'''</span></code>, <code><span class="col-black">'''0==false'''</span></code>. If you have DefaultDbValue on a boolean, you must put 1 or 0. | |||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:Tagged Values]] | [[Category:Tagged Values]] | ||
[[Category:OCL]] | [[Category:OCL]] | ||
{{Edited|July|12| | {{Edited|July|12|2025}} | ||
Latest revision as of 05:30, 7 February 2025
Tagged values
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
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 toupper, tolower, sqllike and sqllikecaseinsensitive handle case conversion.
OCL-PS / Database
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 sqllike and sqllikecaseinsensitive.
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.