strange export beheavior

Classic Servoy
1

I have a table with 2 fields: x (Number) and y (Number)
I have data in this fields: 5,74561 and 50,68018
etc.. (those are GPS-coordinates)

all these values are typed by hand!
If I export this to, for example, a tab-separated file, the values are different: like 5,745610237121582 and 50,680179595947266
Servoy put’s some numbers behind the original! :shock:
After that, if I return to Servoy, the numbers are changed here also!

What is going on here?

2

Most SQL databases store numbers as a Floating point number, this means that not the exact number is stored but an approximation with a certain predefined accuracy. You can round the number back to the number of digits you need. If you want it to be stored exactly as it is store it in a text field. (this will have as a consequence that it will be more difficult to perform caculations on it)