is_utf8(str)
Determines whether the string str contains only characters encoded in UTF-8.
str
> SELECT a, is_utf8(a) FROM VALUES (""), ("abcd"), ("café"), ("©®") AS t(a); true abcd true café true ©® true