String comparison and ordering
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.