SAP Knowledge Base Article - Preview

2793040 - Offline OData database cannot differentiate between capital and lowercase German letters with umlauts


When the offline_db_collation is set to utf8bin an Offline OData $filter query with toLower doesn't work with German umlauts, that is the characters with umlauts are returned as capital letters, despite the toLower option should return with the lowercase version of the given letter(s).



  • SAP Mobile Platform (SMP) SDK 3.0/3.1
  • SAP UltraLite Database (UL/ UDB)


SAP Mobile Platform SDK 3.0 ; SAP Mobile Platform SDK 3.1 ; SAP SQL Anywhere all versions


umlaut, Ä, Ü, É, ß, Ö, tolower(), toupper(), case sensitive, sensitivity, lower case, upper case, capital, letters, startswith, substringof, contains , KBA , MOB-SDK-OOD , SAP Mobile SDK Offline OData Client , BC-SYB-SQA-UL , SQL Anywhere - UltraLite , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.