paequ2@lemmy.today to Programmer Humor@lemmy.mlEnglish · 2 months agoUse this information wiselylemmy.mlimagemessage-square77linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-down1imageUse this information wiselylemmy.mlpaequ2@lemmy.today to Programmer Humor@lemmy.mlEnglish · 2 months agomessage-square77linkfedilink
minus-squareAmazingAwesomator@lemmy.worldlinkfedilinkarrow-up0·2 months agoanother good one to sneak in there… thai zero-width space: U+200B cant see it, nothing reads it, and it makes everything error. : D
minus-squareS_H_K@lemmy.dbzer0.comlinkfedilinkarrow-up0·2 months agoBefore I went to the comments I wished no one mentioned that. As a DBA I fucking hate you…
minus-squareAmazingAwesomator@lemmy.worldlinkfedilinkarrow-up0·2 months agoi am an SDET. this character destroys DBs… i am sorry :(
minus-squareanton@piefed.blahaj.zonelinkfedilinkEnglisharrow-up0·2 months agoThe right to left mark (U+2000F) can also be fun.
minus-squareOnno (VK6FLAB)@lemmy.radiolinkfedilinkarrow-up0·2 months agoHmm … we should start collecting these. Anyone know of an existing list?
minus-square∞🏳️⚧️Edie [it/its, she/her, fae/faer, love/loves, null/void, des/pair, none/use name]@lemmy.mllinkfedilinkarrow-up0·2 months agohttps://invisible-characters.com/
minus-squareJohnnyCanuck@lemmy.calinkfedilinkarrow-up0·2 months agoOh ho! I see what you did there!
minus-squarefloquant@lemmy.dbzer0.comlinkfedilinkarrow-up0·2 months agohttps://github.com/minimaxir/big-list-of-naughty-strings/
minus-squareCallMeAnAI@lemmy.worldlinkfedilinkarrow-up0·2 months agoCame here to say fuck the zero width space. I spent 90 hours in the depths of solr looking for this fucker who brought down our entire search index.
minus-squarederfunkatron@lemmy.worldlinkfedilinkEnglisharrow-up0·2 months agoI deal with shy hyphens a lot. They don’t display unless there’s a line break, so they get copied from various word docs or websites and end up in a database somewhere waiting to piss me off.
minus-squareOnno (VK6FLAB)@lemmy.radiolinkfedilinkarrow-up0·2 months agoI’m guessing that they pasted code from inside Microsoft Word.
minus-squareCallMeAnAI@lemmy.worldlinkfedilinkarrow-up0·2 months agoNo. CMS updated to support new character set while solr did not. Not enough sanitization.
minus-squareOnno (VK6FLAB)@lemmy.radiolinkfedilinkarrow-up0·2 months agoI’ve had similar “fun” with the character defaults on MySQL, from memory for a time it was Swedish by default, rather than UTF.
another good one to sneak in there… thai zero-width space: U+200B
cant see it, nothing reads it, and it makes everything error. : D
Before I went to the comments I wished no one mentioned that. As a DBA I fucking hate you…
i am an SDET. this character destroys DBs… i am sorry :(
The right to left mark (U+2000F) can also be fun.
Hmm … we should start collecting these.
Anyone know of an existing list?
https://invisible-characters.com/
ᅠ
Oh ho! I see what you did there!
https://github.com/minimaxir/big-list-of-naughty-strings/
Came here to say fuck the zero width space. I spent 90 hours in the depths of solr looking for this fucker who brought down our entire search index.
I deal with shy hyphens a lot. They don’t display unless there’s a line break, so they get copied from various word docs or websites and end up in a database somewhere waiting to piss me off.
Yup
I’m guessing that they pasted code from inside Microsoft Word.
No. CMS updated to support new character set while solr did not. Not enough sanitization.
I’ve had similar “fun” with the character defaults on MySQL, from memory for a time it was Swedish by default, rather than UTF.