Subject | Cast to float issues |
---|---|
Author | acalafato |
Post date | 2009-07-06T21:21:57Z |
Hi,
I just upgraded to Firebird 2.1.2, and encountered a problem with casting strings to float which involve commas.
e.g. select cast ("1,000" as float) from rdb$triggers
This used to work in 2.0.3 (returning 1000) but now I'm getting
Invalid modify request.
conversion error from string " 1,000 "
Any ideas for fixes or workarounds?
thanks
Andrew
I just upgraded to Firebird 2.1.2, and encountered a problem with casting strings to float which involve commas.
e.g. select cast ("1,000" as float) from rdb$triggers
This used to work in 2.0.3 (returning 1000) but now I'm getting
Invalid modify request.
conversion error from string " 1,000 "
Any ideas for fixes or workarounds?
thanks
Andrew