Full width chars

SQL

USE commonswiki_p;
/* ASCII files with full width characters. Query by Dispenser.*/
SELECT CONCAT("* [[:File:", img_name, "]]") AS Filename
FROM (SELECT CAST(img_name AS CHAR CHARACTER SET utf8mb4) AS img_name FROM image) AS subquery
WHERE img_name REGEXP "[！-～]" /* U+FF01 - U+FF5E*/
  AND img_name REGEXP "^[!-~ ！-～]+$" /* All ASCII special case */
  AND img_name NOT REGEXP "[＃＜＞［］｜｛｝＿：／＼]"; /* Forbidden characters */

AخA
 
USE commonswiki_p;/* ASCII files with full width characters. Query by Dispenser.*/SELECT CONCAT("* [[:File:", img_name, "]]") AS FilenameFROM (SELECT CAST(img_name AS CHAR CHARACTER SET utf8mb4) AS img_name FROM image) AS subqueryWHERE img_name REGEXP "[！-～]" /* U+FF01 - U+FF5E*/  AND img_name REGEXP "^[!-~ ！-～]+$" /* All ASCII special case */  AND img_name NOT REGEXP "[＃＜＞［］｜｛｝＿：／＼]"; /* Forbidden characters */

SQL

Checking query status...