No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==== Tagged values ==== | ==== Tagged values ==== | ||
When it comes to 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 report 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-PS / Database ==== | ==== OCL-PS / Database ==== | ||
When creating SQL-Server instances you can decide what | 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 | 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. | ||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:Tagged Values]] | [[Category:Tagged Values]] | ||
[[Category:OCL]] | [[Category:OCL]] | ||
Revision as of 07:21, 27 February 2023
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 report 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.