phpmyadmin
Numbers format
Input
Error
Suggestion
It would be better if phpMyAdmin supports this form of numbers.
- 2 451 246
- 2_451_246
Additional context
- phpMyAdmin version: 5.2.3-dev, 6.0.0-dev
PHPMyAdmin is a tool to make it easy to interact with the underlying database engine. It should never be mutating any input in an attempt to guess what the user meant to enter.
Spaces and underscores are not even a standard convention for numerical separator punctuation in spoken languages. What happens when users come to write the INSERT statement in their application and believe that SQL is fine with a number like 2 451 246?
PHPMyAdmin is a tool to make it easy to interact with the underlying database engine.
Yeah exactly, that's why it's okay to simplify things for the user and not stick with SQL, or use SQL instead.
Spaces and underscores are not even a standard convention for numerical separator punctuation in spoken languages. What happens when users come to write the INSERT statement in their application and believe that SQL is fine with a number like 2 451 246?
phpMyAdmin is not a source of SQL knowledge, if someone needs to use SQL, they should learn about it. As I said before phpMyAdmin is an interface to make interaction between user and database easier without the need of using SQL, so it makes sense to make it accept those human readable number formats like 2 451 246 or 2_451_246 as it helps also with copy/pasted values without the need to reformat it for SQL.