[wag]

Hello Ritesh

I have found that the incorrect number of decimals behind the decimal separator probably is caused by mysql. I had truncated the column to have less decimals behind the separator earlier. But somehow the internal representation is only updated when you edit the values. When I edit the values the false decimals drop off and I even see two different decimal representations in the same column!

Greets

[wag]

Hello,

Thanks for the informative reply.

Unchecking Truncate column headers to max data size is a great help in grids with a blob although a bit against intuition and pressing enter to view data is good to know about.

I haven't been able to reproduce my problem with the decimal view. It appears in one table in one database where one column shows 4 decimals while its setting is 2 and that of the column next to it is 4. Copying the table in the same database shows the same behaviour but copying it to another database gets rid of the extra decimals. Strange but not of immediate importance.

Greetings

[wag]

It's wonderful, thanks. 😎

[Author]

Posts