SAP Knowledge Base Article - Preview

2175939 - How to ignore accents in comparisons - SAP IQ

Symptom

If an IQ table contains data with accented characters such as "é", selecting for data that is LIKE "%e%" will return no results because IQ does not see the accented E as an E.

Comparisons between accented characters and similar non-accented characters do not match.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

collation, accent, sensitivity, case, respect, ignore, character, ISO9LATIN1, AccentSensitive, sybase, IQ, create database, UCA , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

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.