Problem MYSQL float limited?
#1

My friend asked me to do this topic now, 'cause he kind of gave up, he was trying I Fize is another way to see if I could, but nothing I exchange is only generated errors or did not work, I just like doing his

We do not know why, but when we create a home is taken the position of the player and played for OutX positions, taking the X player and so for Y and Z and qnd it goes to the database is a somewhat position different than the position that was supposed to be for example

We create a home:
That was the position X, Y, Z in / save
X: 2495.3486
Y: -1690.9208
Z: 14.7656

And that was the OUT X, Y, Z that was saved in the database
X: 2495.35
Y: -1690.92
Z: 14,766

It's all being rounded and out the right position seems we do not know why, and he knows more about the logic and I can not solve, no longer know what to do, he says that the problem is related to MySQL as he had done in DINI and worked absolutely right and when you create the house everything works right, absolutely right, when you restart the server the whole house is outside the right position


----------------------------------------------------------------------------------------------------------------------------------

I tried to change the database, FLOAT to DECIMAL or DOUBLE, DOUBLE but was so
Pos which was to be
2523.1970
-1679.2944
15.4970

Pos who saved
2523.197
-1679.294
15,497

It seems that instead of cutting 2, 1 cut this time
FLOAT, failed, or DOUBLE, DECIMAL I do with?

The decimal saved like this:
2495
-1691
15

That's right, no commas, no longer know what to do, was it not the decimal size 10.0? Someone help me!

Sorry my english
Reply
#2

up!!!
Reply
#3

Why does everyone worry so much about that 0.001 offset. That's like 10 millimeters in the gameworld. Besides, it's correct anyway. If you don't believe me, add "+ 0" in your select.



Holy shit, so much numbers!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)