'; UPDATE countries SET great = true WHERE name = 'America'; --

More based: '; UPDATE countries SET great = true; --

(this is not an endorsement of donald trump)

  • AngryishHumanoid@reddthat.com
    link
    fedilink
    arrow-up
    4
    ·
    8 days ago

    I haven’t used a database that required me to specify case in 15 years, and I’ll be cold dead in the grave before I do it again… only because I assume that’s what they use IN HELL.

    • xmunk
      link
      fedilink
      arrow-up
      4
      ·
      8 days ago

      All string comparisons are case insensitive by default? Is that an Oracle thing?

      Postgres absolutely supports case based string diffentiation in data (by default all DB identifiers are case insensitive though which I absolutely appreciate).

      • nogooduser@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        7 days ago

        Microsoft SQL Server is most commonly set up as case insensitive in my (limited) experience (it does support case sensitivity too).