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

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

(this is not an endorsement of donald trump)

  • xmunk
    link
    fedilink
    arrow-up
    4
    ·
    6 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
      ·
      5 days ago

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