On Sep 17, 2012, at 5:23 PM, "Keith Medcalf" <kmedc...@dessus.com> wrote:
> I don't know if there is a standard for treating empty character strings as > if they were not-present values without first applying one of the builtin > functions designed to deal with NULL. However, my opinion is that SQLite is > correct and Oracle is wrong. Perhaps. In fairness, Oracle predates any 'standard' by a good decade or more. Also, the practical wisdom of treating the empty string as not null is debatable. As demonstrated by this very thread. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users