' . . ' can't insert into a date field,but update can

[wang shuming]

Hi,
  table  table1 int1 int auto_increament ,
                     date date  not null default '0000-00-00'

 1) insert into table1 (date) values('    .  .  ')

 // shows Incorrect date value: '    .  .  ' for column date' at row 1
// '    .  .  ' ==> space(4)+"."+space(2)+"."+space(2)

2) update table1 set date='     .  .  '

  // this done .

I hope can  insert a '    .  .  '  value to a date field .
Mysql 5.0.51

Regards!

Shuming Wang