title: Check how much space a single row takes in Sqlite
body: <p>Is there a way to check how much space a single row takes in Sqlite?</p>
  
  <p>I have tried using this way:</p>
  
  <p>I have 4 fields in my table:</p>
  
  <pre><code>id(int)
  name(text)
  pat(text)
  is_default(bool) 
  </code></pre>
  
  <p></p>
  
  <pre><code> select *, sum(length(id)+length(name)+length(pat)+length(is_default)) 
      from color;
  </code></pre>
  
  <p>But it returns character length (for example: 43). How can I determine the row length in bytes?</p>