Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL TinyInt Problem in salescat/salescatprod
02-08-2015, 12:01 AM (This post was last modified: 02-08-2015 12:06 AM by janb.)
Post: #1
MySQL TinyInt Problem in salescat/salescatprod
FYI
While working with Sales Categories i came across a common problem when using INT types in tables and specially in tables with small space, in this case TinyInt(4) in the salescat and salescatprod tables.
When INT types is used without the UNSIGNED attribute only half space is available for positive numbers (signed INT type also holds space for negative numbers)
In my case i am using more than 127 categories/subcategories in total which is maximum for TinyInt signed (1 byte, 255 records, -128 to +127)
Maybe this is only a minor problem but i think you should consider using TinyInt unsigned instead or maybe SmallInt (2 bytes, 65,535 records)

Jan Bakke
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)