logoalt Hacker News

johnisgoodyesterday at 5:36 PM1 replyview on HN

> Oracle treats empty strings as being NULL.

That is ridiculous. Do not they know the difference between "" and NULL?


Replies

rmunnyesterday at 6:23 PM

I'm pretty sure the historical reasons I mentioned involved creating the software before the SQL standard came out, meaning they were treating NULL as meaning "nothing", instead of meaning "unknown" as the SQL standard requires. But that's as far as I care to go digging into a database system I will never use of my own free will.