Thread Rating:
  • 0 Vote(s) - 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.)
MySQL TinyInt Problem in salescat/salescatprod
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

Forum Jump:

Users browsing this thread: 1 Guest(s)