2489636 - "len" and "char_length" functions do not show correct character count - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2489636 - "len" and "char_length" functions do not show correct character count - SAP ASE

Symptom

  • Functions "len" and "char_length" do not show the correct character count when using nchar columns 
  • The function len(), which according to the documentation specifically "Returns the number of characters, not the number of bytes, of a specified string expression, excluding trailing blanks", actually returns the maximum possible number of bytes for nchar-columns, when the content has no multibyte characters, and other values if it contains multibyte chars.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL05 HF2
  • OS: Linux
  • ASE configured for UTF-8 character set encoding and using nchar columns

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sybase, 808342, CR#808342, CR808342, conversion, length, sortorder, bytes, number of characters, multibyte chars , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.