TO_CODE_POINTS

1
SELECT
2
  text,
3
  TO_CODE_POINTS(text) as code_points
4
FROM UNNEST(['Hello', '你好']) as text;

1
SELECT
2
  code,
3
  CHR(code) as char,
4
  CASE
5
    WHEN code BETWEEN 65 AND 90 THEN 'upper'
6
    WHEN code BETWEEN 97 AND 122 THEN 'lower'
7
    ELSE 'other'
8
  END as type
9
FROM UNNEST(TO_CODE_POINTS('Hello123')) as code;