Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to check how much space a single row takes in Sqlite?

I have tried using this way:

I have 4 fields in my table:

id(int)
name(text)
pat(text)
is_default(bool) 

select *, sum(length(name)+length(name)+length(pat)+length(is_default)) 
from color;

But it returns character length (for example: 43). How can I determine the row length in bytes?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.