SAP Knowledge Base Article - Preview

1912336 - Different behavior between UltraLite database versions with SUBSTRING function

Symptom

  • For an UltraLite database, if you run the following SQL in 9.0.2:
    SELECT SUBSTRING('Hello World', 0, 10)
    it returns 'Hello Worl'
  • Running the same SQL query in UltraLite 12.0 or above, it returns:
    'Hello Wor'


Read more...

Environment

  • SAP UltraLite 12 or above

Product

SAP SQL Anywhere all versions

Keywords

truncation truncate ANSI substring , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.