Are there drawbacks to altering MySQL table data types?

Posted by Tower on Stack Overflow See other posts from Stack Overflow or by Tower
Published on 2010-04-03T16:15:47Z Indexed on 2010/04/03 16:23 UTC
Read the original article Hit count: 193

Filed under:

Hi,

I'm wondering that how much worried I should be about data types. I can easily jump from TINYINT to SMALLINT and from SMALLINT to INT, but are there any drawbacks to this? Obviously situations like from text to int will have consequences, but I'm talking about situations like INT->BIGINT, TINYTEXT->TEXT, etc.

© Stack Overflow or respective owner

Related posts about mysql