Sonderzeichen bei bestimmten Schriften

SQL

SELECT page_title, 'SEITENTITEL'
  FROM page, page_props
 WHERE page_namespace = 0
   AND pp_page = page_id
   AND pp_propname = 'displaytitle'
   # Abfrage ist absichtlich doppelt, CAST ist saulangsam
   # der erste Ausdruck findet Groß- und Kleinschreibung, der zweite filtert dann genauer
   AND CONVERT(pp_value USING utf8mb4) RLIKE "[ẤấẦầẮắẰằẾếỀềỐốỒồḈḉḔḕḖḗḮḯṌṍṎṏṐṑṒṓṸṹṺṻǗǙǛǏǐǘǚǜǧӐӑӒӓЀѐӖӗӁӂӜӝӞӟЍѝӤӥӦӧӰӱӲӳӴӵӸӹӬӭ]"
   AND CAST(CONVERT(pp_value USING utf8mb4) AS binary) RLIKE "[ẤấẦầẮắẰằẾếỀềỐốỒồḈḉḔḕḖḗḮḯṌṍṎṏṐṑṒṓṸṹṺṻǗǙǛǏǐǘǚǜǧӐӑӒӓЀѐӖӗӁӂӜӝӞӟЍѝӤӥӦӧӰӱӲӳӴӵӸӹӬӭ]"
UNION SELECT page_title, ''
  FROM page LEFT JOIN page_props
             ON pp_page = page_id
            AND pp_propname = 'displaytitle'
 WHERE page_namespace = 0
   AND pp_page IS NULL
   AND CONVERT(page_title USING utf8mb4) RLIKE "[ẤấẦầẮắẰằẾếỀềỐốỒồḈḉḔḕḖḗḮḯṌṍṎṏṐṑṒṓṸṹṺṻǗǙǛǏǐǘǚǜǧӐӑӒӓЀѐӖӗӁӂӜӝӞӟЍѝӤӥӦӧӰӱӲӳӴӵӸӹӬӭ]"
   AND CAST(CONVERT(page_title USING utf8mb4) AS binary) RLIKE "[ẤấẦầẮắẰằẾếỀềỐốỒồḈḉḔḕḖḗḮḯṌṍṎṏṐṑṒṓṸṹṺṻǗǙǛǏǐǘǚǜǧӐӑӒӓЀѐӖӗӁӂӜӝӞӟЍѝӤӥӦӧӰӱӲӳӴӵӸӹӬӭ]"
SQL

Checking query status...
