in reply to Re^2: "undef" is not NULL and what to do about it
in thread "undef" is not NULL and what to do about it

"unknown" values are represented - in our case - by a value that falls outside the legal range. e.g. a for numeric values defined to be 0 or greater, we use -1 to be the "undefined" value and -2 to be the "known to be wrong or invalid" value. For strings that decision is taken on each case, some already have a value for "known to be unknown": . (not our choice, it is a law in that database) others might be a single space.

varchar2 is Oracle-only, yet another reason to loathe Oracle. Indeed we use varchar2 instead of varchar, but they suck nevertheless.

I just don't understand how you can say that an empty string equals to NULL. That is only true in the rotten Oracle world.

FWIW I use a lot of database types (Oracle, Unify, MySQL, PostgreSQL, MariaDB, SQLite, CSV, TSV, MonetDB) and NONE is perfect. Oracle is not the only database with drawbacks.

The is more btw, how to represent (in a database)


Enjoy, Have FUN! H.Merijn
pmsig


Comment on Re^3: "undef" is not NULL and what to do about it
Select or Download Code