what is long string types in database code example

Example: sql What type is that value?

SELECT TYPEOF(value);