bigint value comes back rounded in a query

Hi,

I use a bigint to store the ID of my user as I want it to match discord Ids (and they are LONG).

When I look at my db, they are stored correctly with the exact number.

However, once I query them, they are coming back to me with some approximations. I do not want that, I need the exact ID.

How do I fix this ?

Table:

"id"                 "name"    "rank"    "grade"
111204161931972608   "reli"    12         5001

"id"                 "name"    "rank"    "grade"
111204161931972608   "reli"    12         5001

Request:

let {data} = await supabase
      .from("User")
      .select("*")

let {data} = await supabase
      .from("User")
      .select("*")

Response:

{ id: 111204161931972600, name: 'reli', grade: 5001, rank: 12 }

{ id: 111204161931972600, name: 'reli', grade: 5001, rank: 12 }

See how my user id got rounded for the decimals?

Supabase•4y ago•

2 replies

Relisora

bigint value comes back rounded in a query

"id"                 "name"    "rank"    "grade"
111204161931972608   "reli"    12         5001

"id"                 "name"    "rank"    "grade"
111204161931972608   "reli"    12         5001

Request:

let {data} = await supabase
      .from("User")
      .select("*")

let {data} = await supabase
      .from("User")
      .select("*")

Response:

{ id: 111204161931972600, name: 'reli', grade: 5001, rank: 12 }

{ id: 111204161931972600, name: 'reli', grade: 5001, rank: 12 }

See how my user id got rounded for the decimals?

bigint value comes back rounded in a query

Similar Threads

bigint value comes back rounded in a query

Similar Threads

Similar Threads

Similar Threads