New answers tagged null
@Craig provides a detailed explanation and the best advice to avoid the problem: define the column NOT NULL DEFAULT ''. The simple, standard solution for the problem is COALESCE() - like with any other data type that can be NULL. It's a completely reasonable design to allow NULL values in the column, you just have to handle it properly. Your idea with IF ...
Top 50 recent answers are included