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.