- trustnoone ( @trustnoone@lemmy.sdf.org ) 103•10 days ago
I have an apostrophe and it’s super annoying as some companies see it as a SQL injection hack and sanitize it.
So I’ve received ID with Mc%20dole or they add a space in it. Or I’ll get a work email with an apostrophe but I cant use it anywhere because sites have it disabled. And I’ve missed my flight because I changed my ticket once to add the apostrophe and the system just broke at the gate.
Worse yet many flight companies have “you will not be able to board if your ID doesn’t exactly reflect your details” but their form doesn’t allow it. Even most forms for card payments don’t allow it even though it’s the name on my card.
- AdNecrias ( @AdNecrias@lemmy.pt ) 41•10 days ago
%20 is encoded space if I remember right, so even then they were already incorrect
- Fonzie! ( @lord_ryvan@ttrpg.network ) 4•8 days ago
Yep, the apostrophe would be %27
So Mc%27dole
- agilob ( @agilob@programming.dev ) English26•10 days ago
I have an apostrophe and it’s super annoying as some companies see it as a SQL injection hack and sanitize it.
My surname contains a character that’s only present in the Polish alphabet. Writing my full name as is broke lots of systems, encoding, printed paperwork and even British naturalisation application on Home Office website. My surname was part of my username back at uni, and everytime I tried to login on Windows, it would crash underlying LDAP server, logging everyone in the classroom out and forcing ICT to restart the server.
- The Octonaut ( @TheOctonaut@mander.xyz ) 8•10 days ago
… why are you putting an apostrophe in McDole? The O-apostrophe in Irish names is an anglicisation of Ó, eg. Ó Briain becomes O’Brien. Mac Dól would become MacDole/McDole.
- hypnotoad ( @hypnotoad__@lemmy.ml ) English59•10 days ago
Yeah fuck this guy for spelling his name the way it was given to him what an asshole
- Affidavit ( @Affidavit@lemm.ee ) 15•10 days ago
Probably some bureaucrat decades ago making an incorrect assumption that passed down through generations. Happened to my family. No Irish roots whatsoever, yet somehow we ended up with the annoying form-breaking apostrophe in our ‘legal’ name just because it begins with the letter ‘o’.
“Oscar??? Surely, you’re mistaken. I hereby decree your name to be O’Scar!” ~Arsehole circa 1937
- The Octonaut ( @TheOctonaut@mander.xyz ) 2•10 days ago
Hey Militant Left, just because every question directed at you assumes you are an asshole, doesn’t mean the same applies to questions to other people
- JackbyDev ( @JackbyDev@programming.dev ) English7•10 days ago
Mc’Dole is what they said, not McDo’le.
- rekabis ( @rekabis@lemmy.ca ) 6•10 days ago
I have an apostrophe
Scottish/Irish?
some companies see it as a SQL injection hack and sanitize it.
Which kind of apostrophe?
A straight apostrophe, fine - that can and does get used in valid SQL injection attacks. I would be disgusted at any input form that didn’t sanitize that.
But a curly apostrophe? Nothing should be filtering a curly apostrophe, as it has no function or use within SQL. So if you learn how to bring that up in alt codes (Windows, specifically), Key combos (Mac) or dead keys (Linux), as well as direct Unicode codes for most any Win/Mac/*Nix platform, you should be golden.
Unless the developer of that input form was a complete moron and made extra-tight validation.
Plus, knowing the inputs for a lot of extended UTF-8 characters not found on a normal keyboard is also a wee bit of a typing superpower.
- lime! ( @lime@feddit.nu ) English104•10 days ago
asking questions like this is how i found out that one of the allowed characters in names in my country is ÿ, which is fine in Latin-1 but in 7-bit ASCII is
DEL
.- itslilith ( @itslilith@lemmy.blahaj.zone ) 15•10 days ago
that’s amazing! Aren’t codecs fun
- Drew Belloc ( @drew_belloc@programming.dev ) 75•10 days ago
That’s easy, just call it Jhon\nDoe
- 𝕽𝖚𝖆𝖎𝖉𝖍𝖗𝖎𝖌𝖍 ( @sxan@midwest.social ) 55•10 days ago
There are a frightening number of systems that don’t allow “-”, which isn’t even an edge case. A lot of people - mostly women - hyphenate their last names on marriage, rather than throw their old name away. My wife did. She legally changed her name when she came of age, and when we met and married years later she said, “I paid for money for my name; I’m not letting it go.” (Note: I wasn’t pressuring her to take my name.) So she hyphenated it, and has come to regret the decision. She says she should have switched, or not, but the hyphen causes problems everywhere. It’s not a legal character in a lot of systems, including some government systems.
- Affidavit ( @Affidavit@lemm.ee ) 35•10 days ago
It boggles my mind how so many websites and platforms incorrectly say my e-mail address is ‘invalid’ because it has an apostrophe in it.
No. It is NOT invalid. I have been receiving e-mails for years. You just have a shitty developer.
- rumba ( @rumba@lemmy.zip ) English15•10 days ago
worst thing is, the regex to check email has been available for decades and it’s fine with apostrophies
- Ephera ( @Ephera@lemmy.ml ) 11•10 days ago
Well, and remember: If in doubt, send them an e-mail. You probably want to do that anyways to ensure they have access to that mailbox.
You can try to use a regex as a basic sanity check, so they’ve not accidentally typed a completely different info into there, but the e-mail standard allows so many wild mail addresses, that your basic sanity check might as well be whether they’ve typed an
@
into there.- rumba ( @rumba@lemmy.zip ) English7•10 days ago
The regexes are written to comply with RFC 5332 and 6854
They are well defined and you can absolutely definitively check whether an address is allowable or not.
- Ephera ( @Ephera@lemmy.ml ) 6•10 days ago
Yeah, I’m just saying that the benefit of using such a regex isn’t massive (unless you’re building a service which can’t send a mail).
a@b
is a syntactically correct e-mail address. Most combinations of letters, an @-symbol and more letters will be syntactically correct, which is what most typos will look like. The regex will only catch fringe cases, such as a user accidentally hitting the spacebar.And then, personally, I don’t feel like it’s worth pulling in one of those massive regexes (+ possibly a regex library) for most use-cases.
- lad ( @sukhmel@programming.dev ) English1•9 days ago
There are many regexes that validate email, and they usually aren’t compliant with the RFC, there are some details in the very old answer on SO. So, better not validate and just send a confirmation, than restrict and lock people out, imo
- rumba ( @rumba@lemmy.zip ) English1•9 days ago
The article you just mentioned in the comments includes both a completely reasonable and viable regex and binary and library alternatives that are in most languages.
- lad ( @sukhmel@programming.dev ) English1•9 days ago
Reasonable and viable ≠ RFC compliant
This quote summarises my views:
There is some danger that common usage and widespread sloppy coding will establish a de facto standard for e-mail addresses that is more restrictive than the recorded formal standard.
- 𝕽𝖚𝖆𝖎𝖉𝖍𝖗𝖎𝖌𝖍 ( @sxan@midwest.social ) 7•10 days ago
Yes! Hyphens and “+” are also legal, and while most will accept a dash, many don’t allow ‘+’. But it’s explicitly allowed in the spec!
- zagaberoo ( @zagaberoo@beehaw.org ) 4•10 days ago
Ugh and that happens a lot if your email domain has an even slightly unusual TLD too.
- troybot [he/him] ( @troybot@midwest.social ) 14•10 days ago
And you’d think a simple solution is just leave out the hyphen when you put you name in, but that can also lead to problems when the system is looking for a 100% perfect match.
And good luck if they need to scan the barcode on your ID.
- 𝕽𝖚𝖆𝖎𝖉𝖍𝖗𝖎𝖌𝖍 ( @sxan@midwest.social ) 9•10 days ago
Then the first part is interpreted (in the US, anyway) as a middle name, not as part of the last name. I did run into a recently married woman who did that: dropped her middle name, moved her last to the middle, and used her spouse’s last name.
More commonly, places that don’t take hyphens tend to just run the two names together: Axel-Smith becomes AxelSmith.
Programmers can be really dumb.
- Malgas ( @Malgas@beehaw.org ) English6•10 days ago
My mom didn’t hyphenate, but she does include her maiden name when writing her full name, after her middle name. It never even occurred to me that that’s uncommon.
- 𝕽𝖚𝖆𝖎𝖉𝖍𝖗𝖎𝖌𝖍 ( @sxan@midwest.social ) 3•10 days ago
So she writes 4 names? Does she put her maiden and married names both in the “surname” field? Or middle and maiden together in the “middle name” field?
- Riven ( @Riven@lemmy.dbzer0.com ) 6•10 days ago
As someone who’s mexican I encounter that more than one would think since I have 2 last names and it gets weird sometimes since I also have a middle name.
- 𝕽𝖚𝖆𝖎𝖉𝖍𝖗𝖎𝖌𝖍 ( @sxan@midwest.social ) 6•10 days ago
God, the French. My friend has two first names, two middle, and thankfully only one surname.
- Riven ( @Riven@lemmy.dbzer0.com ) 4•10 days ago
Something that could happen in Mexico for a name is Juan Maria as a first, Guillermo David as a middle and Gonzales De Mercado as a last name. Technically 7 words and totally a thing but not common at all, anymore at least.
- Fonzie! ( @lord_ryvan@ttrpg.network ) 1•8 days ago
This kind of makes me want to name my kid Pascal-Case
- ditty ( @dditty@lemm.ee ) English3•9 days ago
There are also fringe externalities from this too. I have my mom’s last name for my middle name and my dad’s for my last name. But back in the 90s, my state would erroneously handle that scenario as having no middle name and both names hyphenated for a last name. I didn’t find this out until I turned 18 and tried to get a retail job and they wouldn’t hire me until it got fixed.
First I had to go to the Dept of Health and get a new birth certificate, then I had to do the same at the social security administration for a new social security card. Hours and hours over multiple days just so I could earn minimum wage folding and selling used clothing. Ironically, the name mixup never was a problem when I did taxes previously.
- JackGreenEarth ( @JackGreenEarth@lemm.ee ) English46•10 days ago
What’s the answer? I need the link
Edit: I found it
- SaharaMaleikuhm ( @SaharaMaleikuhm@feddit.org ) 32•10 days ago
No, cause “John\nDoe” messes up my regex. Sorry, out of the question. I’m not good with regex.
- lseif ( @lseif@sopuli.xyz ) 12•9 days ago
no one is “good” with regex.
- socsa ( @socsa@piefed.social ) English28•10 days ago
If elected president my first order of business will be to make all birth certificates fully unicode compatible.
- agilob ( @agilob@programming.dev ) English13•10 days ago
How is your son
X Æ A-12
?- Phoenixz ( @phoenixz@lemmy.ca ) 7•10 days ago
Screw everything about Elon musk
- Andromxda 🇺🇦🇵🇸🇹🇼 ( @Andromxda@lemmy.dbzer0.com ) English3•10 days ago
“It sounds like a password”
- JohnyRocket ( @JohnyRocket@discuss.tchncs.de ) 5•10 days ago
(ノ-_-)ノ~┻━┻ Miller
- Klnsfw 🏳️🌈 ( @Klnsfw@lemmynsfw.com ) 27•10 days ago
I’d rather include a bell character ‘\a’
- lime! ( @lime@feddit.nu ) English3•10 days ago
Bing Crosby
- frayedpickles ( @frayedpickles@lemmy.cafe ) English24•10 days ago
Can I kill someone who wants to do this? How do I legally get away with it?
- Andromxda 🇺🇦🇵🇸🇹🇼 ( @Andromxda@lemmy.dbzer0.com ) English21•10 days ago
Easy,
John\nDoe
- Nomecks ( @Nomecks@lemmy.ca ) 2•10 days ago
Probably have to escape it so it will work properly: John\/nDoe
- Andromxda 🇺🇦🇵🇸🇹🇼 ( @Andromxda@lemmy.dbzer0.com ) English21•10 days ago
\n
already is an escape sequence, consisting of\
, the escape character, andn
, the code that is responsible for the new line. Together they form an escape sequence.- Bldck ( @Bldck@beehaw.org ) English5•10 days ago
This person unicodes
- Nomecks ( @Nomecks@lemmy.ca ) 1•9 days ago
Sure, but if you don’t escape the \ then you likely won’t even be able to get the name into the first system. You need the name to contain \n so that it gets passed correctly to other systems, otherwise his name may wind up just being “John” .
- Busyvar ( @Busyvar@jlai.lu ) 17•9 days ago
Frontend devs hates this guy.
- TGhost [She/Her] ( @TGhost@lemm.ee ) English16•10 days ago
NaN,
Not a Number, and now Not a Name - ano_ba_to ( @ano_ba_to@sopuli.xyz ) 15•9 days ago
It’s impossible to represent that on paper. It could be misrepresented as a specific number of spaces. Depending on the position on the paper, it may also be hard to tell if the carriage return comes with the line feed. Unless you want the document to be in ASCII or EBCDIC hex, it’s like writing an ambiguous math problem where the answer is different depending on how you were taught about the order of operations. Don’t do this to your kid, Abcde.
- rekabis ( @rekabis@lemmy.ca ) 15•10 days ago
A line break is a non-printable character. So it would only work in the scope of electronic storage. The minute it hits other media, the line break character is subject to how that media handles it’s presence, and then it is lost permanently from that step forward.
Plus, many input forms make use of validation that will just trim anything that isn’t a character or number, removing the line break character.
- Excrubulent ( @Excrubulent@slrpnk.net ) English3•10 days ago
As someone with a very mildly unusual name, I can tell you that it doesn’t matter whether a system could or could not meaningfully represent the name. Often the people or systems just refuse to acknowledge any deviation from what’s expected. Sometimes databases are written to enforce arbitrary grammatical rules that make my name impossible to write, or the people using the systems will just “correct” the “error” without telling me. I don’t mind that much but our normative systems just love to homogenise us.
- Blackmist ( @Blackmist@feddit.uk ) English13•10 days ago
This sounds like the start of another sovcit “loophole”