Cydh Posted April 25, 2013 Posted April 25, 2013 first, I don't know the correct section to post. about item identify value, it's only contains 0 and 1, or there is something else by default? why don't use enum for it? now is using smallint:6 if identify only 0 or 1 is using smallint:6, why refine that 0~20 is tinyint:3? Integer Types (Exact Value)
solid2005 Posted April 25, 2013 Posted April 25, 2013 because they using standard format enum is not available on MSSQL.
goddameit Posted April 25, 2013 Posted April 25, 2013 (edited) I think we can use tinyint(1) or bit(1) Edited April 25, 2013 by goddameit 3
Fanny Posted July 5, 2013 Posted July 5, 2013 (edited) I think you can use tinyint(1) or bool type. enum is a string type data with a value For example, ENUM('a', 'b', 'c') a's value is 1, b's value is 2, and c's value is 3 so it's not suitable for use enum here. Edited July 5, 2013 by Fanny
Recommended Posts