Unicode.sql 981 B

12345678910111213141516171819
  1. /* syntax version 1 */
  2. SELECT
  3. value AS value,
  4. Unicode::Normalize(value) AS normalize,
  5. Unicode::IsUtf(value) AS is,
  6. Unicode::GetLength(value) AS length,
  7. Unicode::Substring(value, 1) AS one_end_substring,
  8. Unicode::Substring(value, 0, 2) AS two_end_substring,
  9. Unicode::RemoveAll(value, "\xD1\x87пr") AS remove_all,
  10. Unicode::LevensteinDistance(value, value || Unicode::Substring(value, 0, 5)) AS levenstein,
  11. Unicode::ToCodePointList(value) AS code_point_list,
  12. Unicode::FromCodePointList(Unicode::ToCodePointList(value)) AS from_code_point_list,
  13. Unicode::FromCodePointList(YQL::LazyList(Unicode::ToCodePointList(value))) AS from_lazy_code_point_list,
  14. Unicode::Reverse(value) AS reverse,
  15. Unicode::Find(value, "ет"u) AS find,
  16. Unicode::RFind(value, "ет"u) AS rfind,
  17. Unicode::Find(value, "ет"u, 7ul) AS find_from,
  18. Unicode::RFind(value, "ет"u, 7ul) AS rfind_from
  19. FROM (SELECT CAST(value AS Utf8) AS value FROM Input);