Re: Null vs empty string and storage

2002-01-26 Thread Michael Collins
Using MySQL 3.23.47, is the best data type for small currency float(4) ? This is for prices of items in a shopping cart for example t-shirts. What is the difference in using float vs decimal? I know I don't need double. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services |||

Null vs empty string and storage

2002-01-25 Thread Michael Collins
Does null take up the same amount of storage as an empty string? If one has a table and stores an empty string in place of NULL for elements that were left blank on a Web form, does that increase storage requirements? Or does having the column already defined mean that storage was already allo