I still think CHAR(01) is the better answer - the column will not be NULL or contain an empty string. The VARCHAR(01) add additional overhead to manage variable strings...

I had the same problem when the database AD account accessing the database was different that the account that created it. I found the following and am in the...