Welcome to WebmasterWorld Guest from 54.167.185.18

Forum Moderators: open

Message Too Old, No Replies

Converting 32 Bit INT to 64 Bit MySQL BIGINT Integer data types

Anything I should know before simply converting all the form types?

   
6:51 am on Jul 31, 2010 (gmt 0)

WebmasterWorld Senior Member jab_creations is a WebmasterWorld Top Contributor of All Time 10+ Year Member



There are a few limitations that I can see hitting by using the 32 bit INT field type in MySQL including the epoch issue so my question is rather simple: should I expect any potential problems in my production environment if I just go through all my database tables and convert the types from INT to BIGINT?

- John