What does SELECT length('héllo'), length(NULL), substr('d… output?

Console output

Why

length() counts characters (so 'héllo' is 5, not its byte count), and length(NULL) is NULL like most functions of NULL. substr uses a 1-based index, so substr('database',5) starts at the 5th character → 'base'.