ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
2 replies
Relisora

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 banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Empty query back.
SupabaseSSupabase / help-and-questions
4y ago
Querying a specific key and value in an array
SupabaseSSupabase / help-and-questions
13mo ago
"No query parameters in this request" in a parameterless query
SupabaseSSupabase / help-and-questions
2mo ago
Check if a value exists in a string?
SupabaseSSupabase / help-and-questions
4y ago