I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.