News for hackers. Stuff that matters.

A comment on What Happened to Vivaldi Social?. Parent comment

Re:What Happened to Vivaldi Social? by vbezhenar on Saturday July 29, 2023 @04:50PM (#36924416)
With empty string there's gotcha: Oracle treats empty string and null as the same values. If you really need sentinel value, generate UUID.
[ Parent | on HN ]
Re:What Happened to Vivaldi Social? by mst on Saturday July 29, 2023 @05:22PM (#36924771)
I believe that's a nasty implementation detail of Oracle and not a problem for anybody using anything else.

A generated UUID, if possible, is probably much more clear because it will only be there if it was inserted very deliberately.

But at that point honestly I'd usually prefer breaking the field out into its own table.

[ Parent | on HN ]