ftFloat-parameters of SQL are converted to locale-format: 10.3 --> 10,3
Original Reporter info from Mantis: tasso
-
Reporter name: Tasso Mulzer
Original Reporter info from Mantis: tasso
- Reporter name: Tasso Mulzer
Description:
I just tried to feed some data from db-aware fields into a MySQL database, works well for strings and integers - but NOT for floats!
No matter if I fill in '10.3' or '10,3' - if I exec SQLQuery.ExecSQL, the float gets converted to the locale of my system (in Germany: '10,3') and is sent to MySQL .. which in turn thinks, it were two fields and rejects the data.
If I switch my computer's locale to English - no problem at all!
Mantis conversion info:
- Mantis ID: 13279
- Fixed in version: 2.4.0
- Fixed in revision: 13010 (#aab8d374)
- Monitored by: » tasso (Tasso Mulzer)
- Target version: 2.4.0