← Back to team overview

maria-discuss team mailing list archive

Re: Locale settings and fractal number

 

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



References