1934948 - Error: SQLCODE -157 "Cannot convert '%1' to a '%2'" when accessing NUMERIC / DECIMAL / FLOAT / DOUBLE international values with commas

Some international languages use a comma (",") as a numeric decimal point indicator.
Attempting to access this international numeric data explicitly as a NUMERIC / DECIMAL / FLOAT / DOUBLE data type in SQL Anywhere fails with the error SQLCODE -157 "Cannot convert %1 to a %2".

SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

11634704 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

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