Weird number overflow behavior between two database types
So I've got two databases that I use when developing locally, one is a Planetscale database and the other is from a docker image
mysql:8.0.31-oracle
I'm transitioning from storing Discord snowflakes as varchars to bigints to make sorting faster and so I don't have to cast them, to do that I'm using the following custom type so I don't have to update everywhere in my codebase to use bigints yet:
What's interesting with this is when using the Planetscale database, it returns the value correctly, but when using the local MySQL database it is off by a bit
Value written: 1154666902883410021
Planetscale returns: 1154666902883410021
Local MySQL returns: 1154666902883410000
which is what you get from doing Number(1154666902883410021
)
If I check the value that's in the local database also I see 1154666902883410021
so I'm not really sure what's happening with this![No description](https://cdn.answeroverflow.com/1155273574236573816/image.png)
Solution:Jump to solution
I am dumb
For anyone else who runs into this problem, in your MySQL2 connection set
![salute](https://cdn.discordapp.com/emojis/1013876843172085882.png)
supportBigNumbers: true
```ts...2 Replies