MySQL r39-2 inserting precise floats
#2

Quote:
Originally Posted by ******
Посмотреть сообщение
The floats you are saving are not precise in the first place - no floats are. If you really care, see IEEE-754 for more information.
The problem is that that floats in-game works, because the objects get created in that positions. But when i insert it into the database they get change, so when i load the objects from the database no objects are created in-game. I'll search IEEE-754.

Example:

In-game cordinates:

X, Y, Z, RX, RY, RZ, (when i create the objects from the server)
-77.943626, 1.293159, 3.117187, -1.000000, -1.000000, -1.000000

In table with DECIMAL(10,6):
-77.944000, 1.293000, 3.117000, -1.000000, -1.000000, -1.000000

You see, they are pretty similar, but with that small change objects aren't created..
Reply


Messages In This Thread
MySQL r39-2 inserting precise floats - by The_Scope - 10.01.2015, 14:09
Respuesta: Re: MySQL r39-2 inserting precise floats - by The_Scope - 10.01.2015, 14:21
Respuesta: Re: MySQL r39-2 inserting precise floats - by The_Scope - 10.01.2015, 14:32
Re: MySQL r39-2 inserting precise floats - by Vince - 10.01.2015, 15:31
Respuesta: Re: MySQL r39-2 inserting precise floats - by The_Scope - 10.01.2015, 17:09

Forum Jump:


Users browsing this thread: 1 Guest(s)