[DiscordArchive] 'stored' where?
[DiscordArchive] 'stored' where?
Original source
(in fact that'll likely mess with common db2 writers which I believe would consider the field length expressed by DBDefs as more trustworthy than field lengths in the original db2, which would lead to different filesizes)
rektbyfaith
04-11-2024, 11:09 AM #31Archived author: Azarchius • Posted: 2024-04-11T11:09:50.959000+00:00
Original source
(in fact that'll likely mess with common db2 writers which I believe would consider the field length expressed by DBDefs as more trustworthy than field lengths in the original db2, which would lead to different filesizes)
Original source
it would turn the actual fields into 64bit
rektbyfaith
04-11-2024, 11:10 AM #32Archived author: Azarchius • Posted: 2024-04-11T11:10:03.222000+00:00
Original source
it would turn the actual fields into 64bit
Original source
(which I don't believe will fuck with the client, but, yeah, don't think that's what we want)
rektbyfaith
04-11-2024, 11:10 AM #33Archived author: Azarchius • Posted: 2024-04-11T11:10:18.784000+00:00
Original source
(which I don't believe will fuck with the client, but, yeah, don't think that's what we want)
Original source
I mean, it could be something on mysql side. But what I can say for sure, is that I have these values as 32bit float before making SQL query for insert.
And there is no data loss from this on my side. So 32 bit float should be enough to express these values
rektbyfaith
04-11-2024, 11:10 AM #34Archived author: Deamon • Posted: 2024-04-11T11:10:47.853000+00:00
Original source
I mean, it could be something on mysql side. But what I can say for sure, is that I have these values as 32bit float before making SQL query for insert.
And there is no data loss from this on my side. So 32 bit float should be enough to express these values
Original source
you store them as 64
rektbyfaith
04-11-2024, 11:10 AM #35Archived author: Azarchius • Posted: 2024-04-11T11:10:57.211000+00:00
Original source
you store them as 64
Original source
that would mean there is no precision loss
rektbyfaith
04-11-2024, 11:11 AM #36Archived author: Azarchius • Posted: 2024-04-11T11:11:00.622000+00:00
Original source
that would mean there is no precision loss
Original source
obviously not if you're using double to store them
rektbyfaith
04-11-2024, 11:11 AM #37Archived author: Azarchius • Posted: 2024-04-11T11:11:08.531000+00:00
Original source
obviously not if you're using double to store them
Original source
I store them as 64 in database. But before storing them this way, they are 32bit floats in memory. And they are converted to text as 32bit floats
rektbyfaith
04-11-2024, 11:11 AM #38Archived author: Deamon • Posted: 2024-04-11T11:11:39.532000+00:00
Original source
I store them as 64 in database. But before storing them this way, they are 32bit floats in memory. And they are converted to text as 32bit floats
Original source
OK, but floats are imprecise _up to_ 32.
rektbyfaith
04-11-2024, 11:12 AM #39Archived author: Azarchius • Posted: 2024-04-11T11:12:02.405000+00:00
Original source
OK, but floats are imprecise _up to_ 32.
Original source
some values will be fucked on attempting to retrieve them as 32
rektbyfaith
04-11-2024, 11:12 AM #40Archived author: Azarchius • Posted: 2024-04-11T11:12:12.818000+00:00
Original source
some values will be fucked on attempting to retrieve them as 32
1 Guest(s)
1 Guest(s)