bcamp1973 Posted February 7, 2007 Share Posted February 7, 2007 I'm working on a cms that's storing text. each entry usuallly isn't all that big, but there will be a LOT of entries generated. Is there a benefit to using TEXT vs BLOB or vis versa? Quote Link to comment Share on other sites More sharing options...
effigy Posted February 7, 2007 Share Posted February 7, 2007 If you're storing text, use text. Text fields are treated as text, while BLOB fields are treated as binary. BLOB fields must also be read in their entirety, while Text fields do not. See the docs. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 8, 2007 Share Posted February 8, 2007 Agreed... I've never really understood why you'd pick a MEDIUM/TINY version of these fields -- once it's variable size, who cares? Quote Link to comment Share on other sites More sharing options...
bcamp1973 Posted February 8, 2007 Author Share Posted February 8, 2007 TEXT it is! Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.