A substring is returned. The return type is set to the input type with the exception of CHAR. A CHAR input has a result type of VARCHAR.
The result character set is the same as the source_string character set for Unicode and Latin. The result character set is Unicode for all other supported character sets.