Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

agnos.is Forums

  1. Home
  2. Technology
  3. Life isn't easy if your last name is 'Null' as it still breaks database entries the world over

Life isn't easy if your last name is 'Null' as it still breaks database entries the world over

Scheduled Pinned Locked Moved Technology
74 Posts 51 Posters 0 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Z [email protected]

    Are there character escapes for SQL, to protect against stuff like that?

    S This user is from outside of this forum
    S This user is from outside of this forum
    [email protected]
    wrote on last edited by
    #27

    Input sanitation typically handles this as a string that only includes characters supported by the data type of the table in question. While in transit, the strings might be escaped at certain stages, such as via URL encoding. Though this is considered poor practice in many applications, it’s not uncommon to see. The point, however, is to prevent the evaluation of inputs as anything other than their intended type, whether or not reserved characters are present.

    1 Reply Last reply
    0
    • P [email protected]

      Wordpress is a sin against mankind.

      A This user is from outside of this forum
      A This user is from outside of this forum
      [email protected]
      wrote on last edited by
      #28

      Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

      1 Reply Last reply
      0
      • P [email protected]

        Wordpress is a sin against mankind.

        A This user is from outside of this forum
        A This user is from outside of this forum
        [email protected]
        wrote on last edited by
        #29

        Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

        narc0tic_bird@lemm.eeN 1 Reply Last reply
        0
        • P [email protected]

          Wordpress is a sin against mankind.

          A This user is from outside of this forum
          A This user is from outside of this forum
          [email protected]
          wrote on last edited by
          #30

          Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

          1 Reply Last reply
          0
          • P [email protected]

            Wordpress is a sin against mankind.

            A This user is from outside of this forum
            A This user is from outside of this forum
            [email protected]
            wrote on last edited by
            #31

            Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

            1 Reply Last reply
            0
            • P [email protected]

              Wordpress is a sin against mankind.

              A This user is from outside of this forum
              A This user is from outside of this forum
              [email protected]
              wrote on last edited by
              #32

              Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

              1 Reply Last reply
              0
              • P [email protected]

                Wordpress is a sin against mankind.

                A This user is from outside of this forum
                A This user is from outside of this forum
                [email protected]
                wrote on last edited by
                #33

                Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

                1 Reply Last reply
                0
                • Z [email protected]

                  Are there character escapes for SQL, to protect against stuff like that?

                  P This user is from outside of this forum
                  P This user is from outside of this forum
                  [email protected]
                  wrote on last edited by
                  #34

                  Use parameters, that way data and queries are separate.

                  1 Reply Last reply
                  0
                  • Z [email protected]

                    Are there character escapes for SQL, to protect against stuff like that?

                    S This user is from outside of this forum
                    S This user is from outside of this forum
                    [email protected]
                    wrote on last edited by
                    #35

                    Yes but it's a dangerous process. You should use paramatrized queries instead.

                    S 1 Reply Last reply
                    0
                    • L [email protected]

                      Legacy systems still handle more traffic than modern ones, I’d wager

                      T This user is from outside of this forum
                      T This user is from outside of this forum
                      [email protected]
                      wrote on last edited by
                      #36

                      And it's probably not seen as urgent enough an issue to need replacing the whole system for.

                      1 Reply Last reply
                      0
                      • C [email protected]
                        This post did not contain any content.
                        C This user is from outside of this forum
                        C This user is from outside of this forum
                        [email protected]
                        wrote on last edited by
                        #37

                        NULL != 'NULL'

                        How do devs make this mistake

                        G blackn1ght@feddit.ukB K kogasa@programming.devK blackmist@feddit.ukB 5 Replies Last reply
                        0
                        • C [email protected]

                          NULL != 'NULL'

                          How do devs make this mistake

                          G This user is from outside of this forum
                          G This user is from outside of this forum
                          [email protected]
                          wrote on last edited by
                          #38

                          How do devs make off by one mistakes.

                          S 1 Reply Last reply
                          0
                          • P [email protected]

                            Yep. For the curious, any time a license plate photo couldn’t be fully read by the automated system, it was marked as “NULL” and he was flagged as the driver. So every single red light camera and speeding camera in the area was sending him to court every day.

                            C This user is from outside of this forum
                            C This user is from outside of this forum
                            [email protected]
                            wrote on last edited by
                            #39

                            It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.

                            takios@discuss.tchncs.deT D 2 Replies Last reply
                            0
                            • C [email protected]

                              It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.

                              takios@discuss.tchncs.deT This user is from outside of this forum
                              takios@discuss.tchncs.deT This user is from outside of this forum
                              [email protected]
                              wrote on last edited by
                              #40

                              Don't they have to prove it with a photograph? In GermanyI'd laugh in theirface withput a photograph as evidence.

                              N 1 Reply Last reply
                              0
                              • P [email protected]

                                I have never seen this happen, and I don't know what tools would confuse the string "null" with NULL. From the comments in this thread, there are evidently more terribly programmed systems than I imagined.

                                S This user is from outside of this forum
                                S This user is from outside of this forum
                                [email protected]
                                wrote on last edited by
                                #41

                                As long as there's javascript somewhere, anything can happen

                                L 1 Reply Last reply
                                0
                                • C [email protected]
                                  This post did not contain any content.
                                  A This user is from outside of this forum
                                  A This user is from outside of this forum
                                  [email protected]
                                  wrote on last edited by
                                  #42

                                  Lmao, I knew a guy from grade school with the last name Null.

                                  S 1 Reply Last reply
                                  0
                                  • C [email protected]

                                    NULL != 'NULL'

                                    How do devs make this mistake

                                    blackn1ght@feddit.ukB This user is from outside of this forum
                                    blackn1ght@feddit.ukB This user is from outside of this forum
                                    [email protected]
                                    wrote on last edited by
                                    #43

                                    It's baffling to me. Maybe I'm just used to using "modern" frameworks, but the only way this could be an issue is if if you literally check if the string value equals "null" and then replace it with a null value.

                                    lastName = lastName.ToUpper() == "NULL" ? null : lastName;

                                    Either that or the database has some bug where it's converting a string value of "null" into a null.

                                    S 1 Reply Last reply
                                    0
                                    • blackn1ght@feddit.ukB [email protected]

                                      It's baffling to me. Maybe I'm just used to using "modern" frameworks, but the only way this could be an issue is if if you literally check if the string value equals "null" and then replace it with a null value.

                                      lastName = lastName.ToUpper() == "NULL" ? null : lastName;

                                      Either that or the database has some bug where it's converting a string value of "null" into a null.

                                      S This user is from outside of this forum
                                      S This user is from outside of this forum
                                      [email protected]
                                      wrote on last edited by
                                      #44

                                      That is something I’ve had to do on rare occasions because people set up and store info in stupid ways…

                                      1 Reply Last reply
                                      0
                                      • A [email protected]

                                        Let's take a blog and slap a whole e-commerce system on it through a plugin and let it auto translate with another one, what could go wrong. wait why is everything so slow, oh i need additional plugins for caching and one more for functionality XYZ why is everything broken now?!?

                                        narc0tic_bird@lemm.eeN This user is from outside of this forum
                                        narc0tic_bird@lemm.eeN This user is from outside of this forum
                                        [email protected]
                                        wrote on last edited by
                                        #45

                                        Maybe your app is based on WordPress :'D

                                        1 Reply Last reply
                                        0
                                        • C [email protected]

                                          It got worse than this, the ticketing company really wanted to get the money from him so when he got hold of a copy of the records and pointed out that one ticket was for a completely different car they modified the records on their end to change the make of car so it would match his. iirc he only got out of it because he had paper copies.

                                          D This user is from outside of this forum
                                          D This user is from outside of this forum
                                          [email protected]
                                          wrote on last edited by
                                          #46

                                          Isn't that falsifying legal documents? In many countries that would land you in jail? Am I wrong, did the people really run that risk?

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups