I have created a temp table and it has a column temp1 whose data type is char(1) and has a default value 'n'. This is a nullable field and can accept only 'y' or 'n' . However when i insert a row in the db without giving me any values it shows the column value too set to 'y'. How does this happen?