Details
-
Task
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
None
Description
Here's the problem: CAD software accessing MariaDB needs columns returned as "number" (so that it can do ">" ">=" etc), but when the number is greater than 1000,
the locale inserts a comma (1,000) that results in the number being passed to subcomponents and interpreted as "1". Using a mysql function that removes "," from the number results in returning a "string" to the application, so numeric comparisons stop working correctly.
There are several possible solutions, but one of the simplest is to be able to alter the locale table to set the thousands_sep to an empty string, OR to be able to add rows to the locale table (so that one could copy the en_US row, with the thousands_sep value changed, for example).
There are other possible solutions, but adding flexibility to locale settings would be beneficial in other contexts.