[Maria-discuss] Locale settings and fractal number
Hello all, I have feature http://www.percona.com/docs/wiki/patches:response_time_distribution Now i want respect locale settings, and use in "time" column locale-depended delimiter instead of current hardcoded ".". I investigate source code about that, and also bugzilla, documentation, but not found answer to my question - where this delimieter setup. What the "official" mysql policy? Use only "."? Or use native-locale? Or use some internal mysql function? Please, resolve my confuse. I want understand how this questions solved in mysql. Thank you very much. --- Oleg Tsarev, Software Engineer, Percona Inc.
Hi, Oleg! On Aug 15, Oleg Tsarev wrote:
Hello all,
I have feature http://www.percona.com/docs/wiki/patches:response_time_distribution Now i want respect locale settings, and use in "time" column locale-depended delimiter instead of current hardcoded ".". I investigate source code about that, and also bugzilla, documentation, but not found answer to my question - where this delimieter setup.
What the "official" mysql policy? Use only "."? Or use native-locale? Or use some internal mysql function? Please, resolve my confuse. I want understand how this questions solved in mysql.
As far as I understand, MySQL typically does not uses system locale information for formatting numbers or dates. Anyway, you shouldn't care about locale - as you have two columns of numbers, you need to have two numeric columns, say, DOUBLE and BIGINT. Regards, Sergei
participants (2)
-
Oleg Tsarev
-
Sergei Golubchik