js
    const { data: userInventory, error: userInventoryError } = await supabase
      .from("inventory")
      .select(`
        serialnumber,
        weapon (
          name,
          rarity
        )
      `)
      .eq("userId", interaction.user.id)
      .eq("weapon.guildId", interaction.guildId)
      .order("rarity", { foreignTable: "weapon", ascending: true })
      .order("name", { foreignTable: "weapon", ascending: true });

I want my data to be sorted by the name of the weapon (string) and by its rarity name (int) But the data comes back like that

json
[
  {
    serialnumber: '95661668BC',
    weapon: { name: 'Glock-18', rarity: 890 }
  },
  {
    serialnumber: '80812853PC',
    weapon: { name: 'Shotgun', rarity: 560 }
  },
  {
    serialnumber: '25487123JI',
    weapon: { name: 'Glock-18', rarity: 890 }
  }
]

Eventhough as you can see G is before S

or am I doing something wrong? please ignore the data im saving, its a game im creating