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 for Me (Login required).

Search for additional results

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