Welcome to WebmasterWorld Guest from

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)

Senior Member from US 

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

joined:Aug 26, 2004
posts: 3169
votes: 22

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