title: Storing Lyrics in a MySQL database
body: <p>I wanted to know what is the best way of storing music "Lyrics" in a mysql database. and what are the setting used for that. Also, i would like the table to store the break lines. </p>
  
  <p>I was thinking about using "|" to indicate a new line and using php to replace string.</p>
  
  <p>I have no idea where to start, or what to use for the parameters (varchar, int (i know it's not going to be int), etc.)</p>
  
  <p>Currently, I have my tracks table laid out like this</p>
  
  <pre><code>table tracks
  ----
  id (int, 10, primary key)
  albumid (foreign key to albums table)
  name (varchar, 50)
  override_artist (overrides album artist if not null)
  playtime (int, 5)
  lyric (??????)
  </code></pre>
  
  <p>Any ideas would be awesome.</p>