maria-discuss team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Oleg Tsarev <zabivator@xxxxxxxxx> writes:

> I use string column, because i need fixed-point number (time column):
> 14_digit_to_second.6_digit_to_microsecond
>
> 123456.654321 as example.
>
> Big number, because i have not only "time" column and also "sum" column too.
> I didn't find any type what good for this, and i use string.

Did you consider using DECIMAL(14,6) ? If so, why can't you use it?

It would seem greatly preferable to use a numeric type for a column with
numbers ...

 - Kristian.