homepage Welcome to WebmasterWorld Guest from 54.237.38.30
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Converting 32 Bit INT to 64 Bit MySQL BIGINT Integer data types
Anything I should know before simply converting all the form types?
JAB Creations

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



 
Msg#: 4179634 posted 6:51 am on Jul 31, 2010 (gmt 0)

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

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved