[SOLVED] Data truncated for column 'Type' at row 1

[jitesh]

Data truncated for column 'Type' at row 1

 

What is the meaning of this error ?

 

Can anyone give idea ?

--------------------------

CREATE TABLE `adcharges` (

  `ID` int(10) NOT NULL auto_increment,

  `AdvtID` int(10) default NULL,

  `Ammount` float(10,2) default NULL,

  `Type` enum('LAYOUT_CHARGE','ADBUILDER_CHARGE','BILLING_CHARGES') default NULL,

  `Status` enum('PAID','UNPAID') default NULL,

  `Date` date default NULL,

  PRIMARY KEY  (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

 

-------------------------

Thanks

[mmarif4u]

What is ur version of mysql.

 

May be:

don't use enum to start with, use DECIMAL, enum stores an approximation

of the value entered into it and shouldn't most likely be used for what you want to.

[jitesh]

Thanks mmarif4u.

 

Solved the problem.