SAP Knowledge Base Article - Public

2074137 - Database field text character limits in SuccessFactors Learning

Symptom

  • What limits the size of certain text fields in SuccessFactors Learning, like the Item description?  When I look at the database definition for the number of characters allowed, I see that many show up to 2000 byte characters, but when typing I am stopped at far less characters. Why does this occur?

Environment

  • Learning

 

Resolution

  • It is true that the field that contains the item description is 2000 bytes long, but the number of characters is going to depend on the type of encoding used in the database. For example UTF-8 characters are 2 bytes each which means that characters take at least 2 bytes each in the field. When using UTF -8 many special characters take more than 2 bytes, so for the Item Description at most the field will hold 1000 characters.
  • For more information about the UTF-8 character set please click the following links.

 

The UTF-8 and Unicode Standards

Wikipedia - UTF-8 

 

Please NOTE that these are external websites and are not under SuccessFactors control.

Keywords

KBA , LOD-SF-LMS , SuccessFactors Learning , How To

Product

SAP SuccessFactors HCM Core all versions