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