News for hackers. Stuff that matters.
Re:Problems with Oracle SQL by robertlagrant on Friday September 10, 2021 @02:20PM (#28485293)
Just store the string "empty" and hope there are no nihilists who've changed their names to match. Simple!
Re:Problems with Oracle SQL by munk-a on Friday September 10, 2021 @04:16PM (#28486410)
Real programmers encode emptiness as ZZZ...

(I once worked maintaining a MUD that used internal memory management and marked block terminals (which were unnecessary since it stored the length of blocks it had allocated) with ZZZ)

Re:Problems with Oracle SQL by robertlagrant on Sunday September 19, 2021 @01:39PM (#28586243)
ZZZ? EEK!
Re:Problems with Oracle SQL by tracker1 on Friday September 10, 2021 @02:59PM (#28485714)
Use vertical tab, or another whitespace or field separator character, like EOF etc. Generally something a modern keyboard won't be entering, and won't generally be transmitted over the wire.
Re:Problems with Oracle SQL by jhgb on Friday September 10, 2021 @07:23PM (#28487970)
Or just prefix everything so that your string domain doesn't shrink? Then you don't have to worry what your users enter.