Close Menu
    DevStackTipsDevStackTips
    • Home
    • News & Updates
      1. Tech & Work
      2. View All

      CodeSOD: A Unique Way to Primary Key

      July 22, 2025

      BrowserStack launches Figma plugin for detecting accessibility issues in design phase

      July 22, 2025

      Parasoft brings agentic AI to service virtualization in latest release

      July 22, 2025

      Node.js vs. Python for Backend: 7 Reasons C-Level Leaders Choose Node.js Talent

      July 21, 2025

      The best CRM software with email marketing in 2025: Expert tested and reviewed

      July 22, 2025

      This multi-port car charger can power 4 gadgets at once – and it’s surprisingly cheap

      July 22, 2025

      I’m a wearables editor and here are the 7 Pixel Watch 4 rumors I’m most curious about

      July 22, 2025

      8 ways I quickly leveled up my Linux skills – and you can too

      July 22, 2025
    • Development
      1. Algorithms & Data Structures
      2. Artificial Intelligence
      3. Back-End Development
      4. Databases
      5. Front-End Development
      6. Libraries & Frameworks
      7. Machine Learning
      8. Security
      9. Software Engineering
      10. Tools & IDEs
      11. Web Design
      12. Web Development
      13. Web Security
      14. Programming Languages
        • PHP
        • JavaScript
      Featured

      The Intersection of Agile and Accessibility – A Series on Designing for Everyone

      July 22, 2025
      Recent

      The Intersection of Agile and Accessibility – A Series on Designing for Everyone

      July 22, 2025

      Zero Trust & Cybersecurity Mesh: Your Org’s Survival Guide

      July 22, 2025

      Execute Ping Commands and Get Back Structured Data in PHP

      July 22, 2025
    • Operating Systems
      1. Windows
      2. Linux
      3. macOS
      Featured

      A Tomb Raider composer has been jailed — His legacy overshadowed by $75k+ in loan fraud

      July 22, 2025
      Recent

      A Tomb Raider composer has been jailed — His legacy overshadowed by $75k+ in loan fraud

      July 22, 2025

      “I don’t think I changed his mind” — NVIDIA CEO comments on H20 AI GPU sales resuming in China following a meeting with President Trump

      July 22, 2025

      Galaxy Z Fold 7 review: Six years later — Samsung finally cracks the foldable code

      July 22, 2025
    • Learning Resources
      • Books
      • Cheatsheets
      • Tutorials & Guides
    Home»News & Updates»Representative Line: National Exclamations

    Representative Line: National Exclamations

    July 16, 2025

    Carlos and Claire found themselves supporting a 3rd party logistics package, called IniFreight. Like most “enterprise” software, it was expensive, unreliable, and incredibly complicated. It had also been owned by four different companies during the time Carlos had supported it, as its various owners underwent a series of acquisitions. It kept them busy, which is better than being bored.

    One day, Claire asked Carlos, “In SQL, what does an exclamation point mean?”

    “Like, as a negation? I don’t think most SQL dialects support that.”

    “No, like-” and Claire showed him the query.

    select * from valuation where origin_country < '!'
    

    “IniFreight, I presume?” Carlos asked.

    “Yeah. I assume this means, ‘where origin country isn’t blank?’ But why not just check for NOT NULL?”

    The why was easy to answer: origin_country had a constraint which prohibited nulls. But the input field didn’t do a trim, so the field did allow whitespace only strings. The ! is the first printable, non-whitespace character in ASCII (which is what their database was using, because it was built before “support wide character sets” was a common desire).

    Unfortunately, this means that my micronation, which is simply spelled with the ASCII character 0x07 will never show up in their database. You might not think you’re familiar with my country, but trust me- it’ll ring a bell.

    [Advertisement]
    Utilize BuildMaster to release your software with confidence, at the pace your business demands. Download today!

    Source: Read More 

    Facebook Twitter Reddit Email Copy Link
    Previous ArticleCritical Sudo Vulnerabilities Let Local Users Gain Root Access on Linux, Impacting Major Distros
    Next Article Poweradmin – web-based DNS administration tool

    Related Posts

    News & Updates

    The best CRM software with email marketing in 2025: Expert tested and reviewed

    July 22, 2025
    News & Updates

    This multi-port car charger can power 4 gadgets at once – and it’s surprisingly cheap

    July 22, 2025
    Leave A Reply Cancel Reply

    For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

    Continue Reading

    Waze vs. Google Maps: Which navigation app is best?

    News & Updates

    Windows 11 update KB5060829 triggering misleading firewall error

    Operating Systems

    I recommend this $320 Lenovo tablet over the iPad for most people. Here’s why

    News & Updates

    I spoke with an AI version of myself, thanks to Hume’s free tool – how to try it

    News & Updates

    Highlights

    Citrix Bleed 2: ReliaQuest Warns of Active Exploitation in NetScaler Gateway Vulnerability

    June 29, 2025

    Citrix Bleed 2: ReliaQuest Warns of Active Exploitation in NetScaler Gateway Vulnerability

    A newly discovered vulnerability—CVE-2025-5777, now dubbed Citrix Bleed 2—is raising serious security alarms. According to ReliaQuest, attackers are actively exploiting this vulnerability in the wild …
    Read more

    Published Date:
    Jun 30, 2025 (3 hours ago)

    Vulnerabilities has been mentioned in this article.

    CVE-2025-6543

    CVE-2025-5777

    CVE-2025-31324

    CVE-2024-6235

    CVE-2023-4966

    CVE-2025-5173 – HumanSignal Label Studio ML Backend Deserialization Vulnerability

    May 26, 2025

    CVE-2025-3112 – Apache Webserver Resource Exhaustion Denial of Service

    June 10, 2025

    CVE-2025-32788 – OctoPrint Authentication Bypass

    April 22, 2025
    © DevStackTips 2025. All rights reserved.
    • Contact
    • Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.