SAP Knowledge Base Article - Preview

2356341 - UTF8 SQL Anywhere database is case insensitive


  • You set CaseSensitivity option to Ignore but Unicode characters are not case sensitive
  • This happens to data in CHAR type column



  • SAP SQL Anywhere - any supported versions
  • Sybase SQL Anywhere - any supported versions


SAP SQL Anywhere all versions ; SQL Anywhere all versions


asa, anyhwere, case, sensitivity, UTF8BIN, UCA, Unicode collation algorithm, special, foreign, non-western, dbinit, collation, tailoring, tailor, option, setting , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , BC-SYB-SQA-SRV , SQL Anywhere - Server , Problem

About this page

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

Search for additional results

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