Unicode.sql 639 B

123456789101112131415
  1. /* syntax version 1 */
  2. SELECT
  3. value AS value,
  4. Unicode::IsUtf(value) AS is,
  5. Unicode::GetLength(value) AS length,
  6. Unicode::Substring(value, 1) AS one_end_substring,
  7. Unicode::Substring(value, 0, 2) AS two_end_substring,
  8. Unicode::RemoveAll(value, "\xD1\x87пr") AS remove_all,
  9. Unicode::LevensteinDistance(value, value || Unicode::Substring(value, 0, 5)) AS levenstein,
  10. Unicode::Reverse(value) AS reverse,
  11. Unicode::Find(value, "ет"u) AS find,
  12. Unicode::RFind(value, "ет"u) AS rfind,
  13. Unicode::Find(value, "ет"u, 7ul) AS find_from,
  14. Unicode::RFind(value, "ет"u, 7ul) AS rfind_from
  15. FROM Input