MySQL: Large VARCHAR vs. TEXT? I've got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (all integer types) I need to save the actual message text as either VARCHAR or TEXT. I'm setting a front-end limit of 3000 characters which means the messages would never be inserted into the db as longer than this. Is there a rationale for going with either VARCHAR(3000) or TEXT? There's something about just writing VARCHAR(3000) that feels somewhat counter-intuitive.

How to vertically center text with CSS? I have a div tag which contains text, and I want to align the contents of this div vertically center. Here is my div style: #box { height: 90px; width: 270px; background: #000; font-size: 48px; font-style: oblique; color: #FFF; text-align: center; margin-top: 20px; margin-left: 5px; } <div Id="box"> Lorem ipsum dolor sit amet, consectetur adipiscing elit. </div> What is the best way to do this? answer :  You can try this basic approach: div { height: