What is the different between bit(1) and tinyint(1) are they the same? This happens while we migrated data from a older version of mysql (maybe 5.1) to the latest version (say 5.5). Are they functionally the same
Asked
Active
Viewed 462 times
-3
Sam
- 8,387
- 19
- 62
- 97
-
What does documentation say about this? – Sergio Tulentsev Feb 04 '13 at 06:47
-
http://stackoverflow.com/questions/290223/what-is-the-difference-between-bit-and-tinyint-in-mysql – Devendra Feb 04 '13 at 06:48
1 Answers
0
- BIT(m)
A bit-field type. M indicates the number of bits per value, from 1 to 64. The default is 1 if M is omitted.
- TINYINT(m)
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
John Woo
- 258,903
- 69
- 498
- 492