Crono$UnicodeTable

Devuelve la tabla de caracteres UNICODE.

La siguiente consulta muestra algunos caracteres UNICODE.

select
  CodePoint,
  highSurrogate,
  lowSurrogate,
  [hex],
  [char],
  [Unicode]
from Crono$UnicodeTable
where
  codepoint between 65 and 69
  or codepoint between 0x1F600  and 0x1F607
order by 1

Ver SQL compilado

SELECT
  CodePoint,
  highSurrogate,
  lowSurrogate,
  [hex],
  [char],
  Unicode
FROM
  (SELECT
     c.num AS CodePoint,
     CASE WHEN c.num>65535 THEN convert(char(4),cast(0xD7C0+(c.num/1024) as binary(2)),2) END AS highSurrogate,
     CASE WHEN c.num>65535 THEN convert(char(4),cast(0xDC00+(c.num%1024) as binary(2)),2) END AS lowSurrogate,
     CONVERT(char(6),CONVERT(binary(3),c.num),2) AS [hex],
     CASE WHEN c.num>65535 THEN nchar(CAST(0xD7C0+(c.num/1024) AS int))+nchar(CAST(0xDC00+(c.num%1024) AS int)) ELSE nchar(c.num) END AS [char],
     concat('U+',CONVERT(char(6),CONVERT(binary(3),c.num),2)) AS Unicode,
     concat('0x',CONVERT(char(6),CONVERT(binary(3),c.num),2)) AS Bin,
     concat('&#x',CONVERT(char(6),CONVERT(binary(3),c.num),2)) AS HTML,
     CASE
         WHEN c.num>65535 THEN concat('nchar(0x',convert(char(4),cast(0xD7C0+(c.num/1024) as binary(2)),2),')+nchar(0x',convert(char(4),cast(0xDC00+(c.num%1024) as binary(2)),2),')')
         ELSE concat('nchar(',c.num,')')
     END AS TSQL
   FROM
     (SELECT u1.n+u2.n*10+u3.n*100+u4.n*1000+u5.n*10000+u6.n*100000+u7.n*1000000 num
      FROM
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u1,
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u2,
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u3,
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u4,
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u5,
        (SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u6,
        (SELECT 0 n UNION SELECT 1) u7
      WHERE u1.n+u2.n*10+u3.n*100+u4.n*1000+u5.n*10000+u6.n*100000+u7.n*1000000 BETWEEN 0 AND 1114110) c
   WHERE
     c.num BETWEEN 0x000000 AND 0x014700
     OR c.num BETWEEN 0x016800 AND 0x030000
     OR c.num BETWEEN 0x0E0001 AND 0x0E01EF) [Crono$UnicodeTable]
WHERE
  CodePoint BETWEEN 65 AND 69
  OR CodePoint BETWEEN 0x1F600 AND 0x1F607
ORDER BY 1

El resultado de esta consulta es:

CodePoint	highSurrogate	lowSurrogate	hex	char	Unicode
65			000041	A	U+000041
66			000042	B	U+000042
67			000043	C	U+000043
68			000044	D	U+000044
69			000045	E	U+000045
70			000046	F	U+000046
71			000047	G	U+000047
72			000048	H	U+000048
73			000049	I	U+000049
74			00004A	J	U+00004A
75			00004B	K	U+00004B
76			00004C	L	U+00004C
77			00004D	M	U+00004D
78			00004E	N	U+00004E
79			00004F	O	U+00004F
80			000050	P	U+000050
81			000051	Q	U+000051
82			000052	R	U+000052
83			000053	S	U+000053
84			000054	T	U+000054
85			000055	U	U+000055
86			000056	V	U+000056
87			000057	W	U+000057
88			000058	X	U+000058
89			000059	Y	U+000059
90			00005A	Z	U+00005A
128512	D83D	DE00	01F600	😀	U+01F600
128513	D83D	DE01	01F601	😁	U+01F601
128514	D83D	DE02	01F602	😂	U+01F602
128515	D83D	DE03	01F603	😃	U+01F603
128516	D83D	DE04	01F604	😄	U+01F604
128517	D83D	DE05	01F605	😅	U+01F605
128518	D83D	DE06	01F606	😆	U+01F606
128519	D83D	DE07	01F607	😇	U+01F607

Comentarios

Esta vista es similar a Crono$UnicodeChars.

La vista Crono$Emojis devuelve únicamente caracteres emojis con información adicional.