The BIRT iHub Integration service compares and orders strings according to the Unicode code point value of each character. For example, Bright‑Abbott is sorted before Brightman because the hyphen (-) has a Unicode value of 45, while lowercase m has a Unicode value of 109. The expression:
'Kirsten' LIKE 'ki%'
evaluates to False because uppercase K is different from lowercase k.
Although string comparison is case-sensitive by default, you can configure the Integration service to do case-insensitive comparison and ordering.