{"id":4904,"date":"2012-12-04T16:31:45","date_gmt":"2012-12-04T22:31:45","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=4904"},"modified":"2021-12-08T10:31:44","modified_gmt":"2021-12-08T16:31:44","slug":"case-sensitivity-within-applications","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/case-sensitivity-within-applications","title":{"rendered":"Case Sensitivity within Applications"},"content":{"rendered":"<h1><\/h1>\n<p><iframe src=\"\/\/www.youtube.com\/embed\/RuKLoZToerA\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p class=\"scriptbutton\"><input id=\"script1\" class=\"toggleScript\" type=\"button\" value=\"Show Video Script\" \/><\/p>\n<p class=\"script script1\">Occasionally, searching in m-Power may result in returning no matching records, despite matching records existing. For example, the value \u2018Chicago\u2019 clearly exists within the CITY field in this retrieval. Now, I\u2019ll search for \u2018Chicago\u2019. Despite the value \u2018Chicago\u2019 existing, matching records are not found. However, if I search for a numeric value, the search returns as expected.<\/p>\n<p>This is a result of case sensitivity. To fix this, we need to look in the SQL Statement tab in Application Properties. Here you will find the caseSensitive property, which has three options. By default, m-Power will change the search value to uppercase. In my example, the record that I was searching for had lowercase letters\u2014but m-Power assumed that I wanted to search in uppercase. This is why no records were returned.<\/p>\n<p>Therefore, I need to select either of the remaining options. If I were to select \u2018No case conversion\u2019, my search value needs to be an exact match, including case, to the record in the database. Selecting the last option will change both my database record and my search value to uppercase, returning any records that are a letter-for-letter match regardless of case.<\/p>\n<p>After changing this property to convert both values to uppercase, my search returns the expected record, no matter the case.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Occasionally, searching in m-Power may result in returning no matching records, despite matching records existing. For example, the value \u2018Chicago\u2019 clearly exists within the CITY field in this retrieval. Now, I\u2019ll search for \u2018Chicago\u2019. Despite the value \u2018Chicago\u2019 existing, matching records are not found. However, if I search for a&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[264],"ht-kb-tag":[],"class_list":["post-4904","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-deprecated-documentation"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/4904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=4904"}],"version-history":[{"count":10,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/4904\/revisions"}],"predecessor-version":[{"id":12345,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/4904\/revisions\/12345"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=4904"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=4904"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=4904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}