Mysql incorrect decimal value in view

Asked

Viewed 32 times

1

I don’t know why the number 9937.77 stored in Mysql as Decimal(12.2) displays 9 million in views 1.00 displays 100 (1.00 is correct) 5.77 displays 577 (5.77 is correct)

inserir a descrição da imagem aqui

I tried to

DisplayFor(m => m.MyNumber)
Model.MyNumber.toString("n2")
Model.MyNumber.toString("C")

Mysql Decimal(12,2)

Default collation utf8mb4_0900_ai_ci
Default chartset utf8mb4
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.