> SELECT avg(length(domain)) from domains; > > The response is 10 and not 4.
>From <http://www.sqlite.org/lang_expr.html>: length(X) Return the string length of X in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.