Question:
Is there an issue with data case sensitivity between SFDC online and Veeva's Offline app on iPad?
Answer:
iPad utilizes SQLlite which does take case sensitivity into consideration when an object needs to be queried Offline. SFDC's SOQL only considers IDs case sensitive. SOQL vs. SQLlite case sensitivity difference should be taken into consideration anytime a specific field other than ID is used in a query Offline.
Example, if an Account View is configured to query the Territory Specific Field (TSF) object, the territory referenced in the query needs to be in the exact case as it is in the record.
Related Documentation:
CRM Help Documentation: N/A