Mysql Workbench - Insert number with comma in DOUBLE => Error

Question

I have a database with DOUBLE fields.

I can't insert number like 19,50, ...

But 19.50 works...

Any ideas ?

Thanks !

possible duplicate of [Change decimal separator in MySQL](http://stackoverflow.com/questions/8669212/change-decimal-separator-in-mysql) — Jim, Jan 30 '14 at 14:45
The SQL standard specifies `.` as the decimal separator. Using `,` isn't possible in MySQL. — Jim, Jan 30 '14 at 14:46

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

Parse strings to double with comma and point might give you a few suggestions. I'm assuming here the comma number is a string.

edited May 23 '17 at 10:25

Community

answered Jan 30 '14 at 14:48

Stuart Palmer

1 Answers1