[DiscordArchive] 24bit though?
[DiscordArchive] 24bit though?
Archived author: Deamon • Posted: 2024-04-11T11:20:50.593000+00:00
Original source
it must be mysql thing
Archived author: Azarchius • Posted: 2024-04-11T11:21:02.465000+00:00
Original source
maybe mysql is chopping off some bits because it is trying to guess precision based on values in the table
Archived author: Azarchius • Posted: 2024-04-11T11:21:08.104000+00:00
Original source
trying to "optimize" the size of the field
Archived author: Deamon • Posted: 2024-04-11T11:21:19.943000+00:00
Original source
from what I read on mysql help `float(24)` field type should be enough for storing these values
Archived author: Azarchius • Posted: 2024-04-11T11:21:24.044000+00:00
Original source
we certainly don't have any values that are very deep into precision, it's mostly 458123478.0 kinda deal.
Archived author: Deamon • Posted: 2024-04-11T11:21:26.292000+00:00
Original source
and it's still 32bit
Archived author: Azarchius • Posted: 2024-04-11T11:22:13.108000+00:00
Original source
actually, scratching my head here, I'm kinda full of shit actually, even the ints are floats if it reads as point 0.
Archived author: Deamon • Posted: 2024-04-11T11:22:30.857000+00:00
Original source
this
Archived author: Azarchius • Posted: 2024-04-11T11:22:32.824000+00:00
Original source
is that what you were saying? didn't click
Archived author: Azarchius • Posted: 2024-04-11T11:22:38.485000+00:00
Original source
makes sense, ok