Submitted by: markit (markit)

SFID: 223789#⁠
Submitted By: markit

If you declare the function ascii_char like stated in the documentation or in the example provided in InterBase\examples\Udf\ib_udf.sql, i.e.:
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CHAR(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

if you use it, i.e.:
select ascii_char(65) from rdb$database
you will receive the error:
"-arithmetic exception, numeric overflow, or string truncation -"
That's because the declaration ha to be different:
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';