mysql-test/include/ctype_unicode_ws_supplementary.inc


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

--source include/have_utf32.inc
--source include/have_sequence.inc

EXECUTE IMMEDIATE SFORMAT('
CREATE VIEW v_supplementary AS
SELECT
  seq AS codepoint,
  CONVERT(CHAR(seq USING utf32) USING {}) COLLATE {} AS c
FROM
  seq_65536_to_1114111', @@character_set_connection, @@collation_connection);

SELECT COLLATION(c) FROM v_supplementary LIMIT 1;

SELECT
  SUM(HEX(WEIGHT_STRING(c))<>'FFFD'),
  SUM(HEX(WEIGHT_STRING(c))='FFFD')
FROM v_supplementary;

DROP VIEW v_supplementary;