>>   Another possibility is to set coercion rules for new data type for your 
>> connection, see

>>https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-msql-set-bind-native-to-legacy-coercion-rules

Thanks Vlad! In this example from this link:

SET BIND OF DECFLOAT TO DOUBLE PRECISION;
SELECT CAST('123.45' AS DECFLOAT(16)) FROM RDB$DATABASE;        --double

Does this need to be done within every transaction that is started, or per 
connection/session, or once off per database?

Thanks
Maya

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to