[SOLVED] double attributes are saved as int

Hi, I don't know if it's my fault but I save the values as double but they are saved as int.

which causes me an error, because I expect a double value

As far as I can see, appwrite approximates the closest value, but that's not what I want. Is there any way to disable this approximation?

Hi - let me take a look at this

are you writing values in console?

can you please elaborate a bit about how you are storing values so i can see if this could be a bug?

Either way, it doesn't save as a double value. Either saving from the console for example default value or values saved from the project

although creating a document from the console does work

we tried replicating this and we are able to make the document with decimal values. Can you elaborate on what are you exactly trying to do (the steps) and/or code piece so we can see what's happening

I already found the reason. It is because when we save a value, for example 25.0, it is saved as 25.
But if 25.1 is saved if the double value is respected.

but this generates problems for me because I would have to be converting the values obtained to double

Tagging @Torsten Dittmann here

This might be an interesting issue. I am pretty sure on the backend its handled properly, but Javascript/the browser uses the same data type for both int/float values.

So it is properly saved into the backend, but the moment Javascript gets it from the Database, it makes it an integer. On many other languages it should be interpreted correctly.

Mmm I understand. And it is not possible to make a condition .endsWith(".00") and if it is fulfilled, apply a toFixed?

or the best solution would be to convert the values obtained from the database back to double? although it should be an unnecessary task

In flutter, you'll need to convert/cast it to a double

From the Appwrite side, it is expected to return something like:

{
  "price": 333
}

JSON is JavaScript and JavaScript does not differentiate between int or double. As such, whole numbers will be simplified to drop the decimals.

In a language that differentiates the two, you'll have to convert it accordingly. For example, you can do json["price"]?.toDouble().

or you can use the num type

Ok friend thanks, if there is no other way I will choose to convert the values to double 👍

[SOLVED] double attributes are saved as int