This question already has an answer here:
I would like to insert a double or float number to mysql, for example 2371.80 €. In my country we are writting 2371.80€ like 2.371,80€. Can I insert number like 2.371,80€??
I know that can i use str_replace() and length() to add or change characters, but i want to do this when run insert query.
Also i tried to change unicode but nothing.
Can anyone help me?
</div>
No, you can't. That's the SQL standard and MySQL complies with it. Comma , is also used as values separator.
INSERT INTO a(b,c) VALUES (3,4,5) would be ambiguous.
or you can use
varchar
for adding as string