| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/jp/r/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 15 kB |
|
Quelle jp_trim_sjis.result Sprache: Lisp |
|||||||||||||||
|
SET NAMES sjis; SET character_set_database = sjis; DROP TABLE IF EXISTS `‚s‚P`; DROP TABLE IF EXISTS `‚s‚Q`; DROP TABLE IF EXISTS `‚s‚R`; CREATE TABLE `‚s‚P` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚Q` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚R` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ INSERT INTO `‚s‚P` VALUES ('±²³´µ'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES ('¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES (' ±²³´µ '); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨ '); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES ('–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES (' ƒ\\•\—\\ '); SELECT `‚b‚P`,TRIM(TRAILING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(TRAILING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ SELECT `‚b‚P`,TRIM(LEADING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(LEADING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ¶¶¶ SELECT `‚b‚P`,TRIM(BOTH '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(BOTH '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(`‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ¶¶¶ SELECT `‚b‚P`,TRIM(TRAILING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(TRAILING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(LEADING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(LEADING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© SELECT `‚b‚P`,TRIM(BOTH '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(BOTH '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(`‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© SELECT `‚b‚P`,TRIM(TRAILING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(TRAILING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(LEADING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(LEADING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ SELECT `‚b‚P`,TRIM(BOTH '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(BOTH '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(`‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\–\–\–\ DROP TABLE `‚s‚P`; DROP TABLE `‚s‚Q`; DROP TABLE `‚s‚R`; SET NAMES sjis; SET character_set_database = sjis; DROP TABLE IF EXISTS `‚s‚P`; DROP TABLE IF EXISTS `‚s‚Q`; DROP TABLE IF EXISTS `‚s‚R`; CREATE TABLE `‚s‚P` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚Q` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚R` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ INSERT INTO `‚s‚P` VALUES ('±²³´µ'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES ('¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES (' ±²³´µ '); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨ '); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES ('–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES (' ƒ\\•\—\\ '); SELECT `‚b‚P`,TRIM(TRAILING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(TRAILING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ SELECT `‚b‚P`,TRIM(LEADING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(LEADING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ¶¶¶ SELECT `‚b‚P`,TRIM(BOTH '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(BOTH '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(`‚b‚P`) ±²³´µ ±²³´µ ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ¶¶¶ SELECT `‚b‚P`,TRIM(TRAILING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(TRAILING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(LEADING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(LEADING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© SELECT `‚b‚P`,TRIM(BOTH '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(BOTH '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(`‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© SELECT `‚b‚P`,TRIM(TRAILING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(TRAILING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(LEADING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(LEADING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ SELECT `‚b‚P`,TRIM(BOTH '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(BOTH '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(`‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\–\–\–\ DROP TABLE `‚s‚P`; DROP TABLE `‚s‚Q`; DROP TABLE `‚s‚R`; SET NAMES sjis; SET character_set_database = sjis; DROP TABLE IF EXISTS `‚s‚P`; DROP TABLE IF EXISTS `‚s‚Q`; DROP TABLE IF EXISTS `‚s‚R`; CREATE TABLE `‚s‚P` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚Q` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ CREATE TABLE `‚s‚R` (`‚b‚P` CHAR(12), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis ENGINE = <engine_to_be_ INSERT INTO `‚s‚P` VALUES ('±²³´µ'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶'); INSERT INTO `‚s‚P` VALUES ('±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES ('¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ'); INSERT INTO `‚s‚P` VALUES ('¶¶¶±²³´µ¶¶¶'); INSERT INTO `‚s‚P` VALUES (' ±²³´µ '); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES ('‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨'); INSERT INTO `‚s‚Q` VALUES ('‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚©'); INSERT INTO `‚s‚Q` VALUES (' ‚ ‚¢‚¤‚¦‚¨ '); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\'); INSERT INTO `‚s‚R` VALUES ('ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES ('–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\'); INSERT INTO `‚s‚R` VALUES ('–\–\–\ƒ\\•\—\\–\–\–\'); INSERT INTO `‚s‚R` VALUES (' ƒ\\•\—\\ '); SELECT `‚b‚P`,TRIM(TRAILING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(TRAILING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ ±²³´µ ±²³´µ SELECT `‚b‚P`,TRIM(LEADING '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(LEADING '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ¶¶¶ ±²³´µ ±²³´µ SELECT `‚b‚P`,TRIM(BOTH '¶' FROM `‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(BOTH '¶' FROM `‚b‚P`) ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ ±²³´µ¶¶ ±²³´µ ±²³´µ¶¶¶ ±²³´µ ¶±²³´µ ±²³´µ ¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ ±²³´µ ¶¶¶±²³´µ¶¶¶ ±²³´µ ±²³´µ ±²³´µ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚P`; ‚b‚P TRIM(`‚b‚P`) ±²³´µ ±²³´µ ±²³´µ¶ ±²³´µ¶ ±²³´µ¶¶ ±²³´µ¶¶ ±²³´µ¶¶¶ ±²³´µ¶¶¶ ¶±²³´µ ¶±²³´µ ¶¶±²³´µ ¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ ¶¶¶±²³´µ¶¶¶ ¶¶¶±²³´µ¶¶¶ ±²³´µ ±²³´µ SELECT `‚b‚P`,TRIM(TRAILING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(TRAILING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(LEADING '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(LEADING '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(BOTH '‚©' FROM `‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(BOTH '‚©' FROM `‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚Q`; ‚b‚P TRIM(`‚b‚P`) ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨ ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚©‚©‚©‚ ‚¢‚¤‚¦‚¨‚©‚©‚© ‚ ‚¢‚¤‚¦‚¨ ‚ ‚¢‚¤‚¦‚¨ SELECT `‚b‚P`,TRIM(TRAILING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(TRAILING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(LEADING '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(LEADING '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(BOTH '–\' FROM `‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(BOTH '–\' FROM `‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\ ƒ\\•\—\\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ –\ƒ\\•\—\\ ƒ\\•\—\\ –\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\ SELECT `‚b‚P`,TRIM(`‚b‚P`) FROM `‚s‚R`; ‚b‚P TRIM(`‚b‚P`) ƒ\\•\—\\ ƒ\\•\—\\ ƒ\\•\—\\–\ ƒ\\•\—\\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\ ƒ\\•\—\\–\–\–\ ƒ\\•\—\\–\–\–\ –\ƒ\\•\—\\ –\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\ –\–\–\ƒ\\•\—\\–\–\–\ –\–\–\ƒ\\•\—\\–\–\–\ ƒ\\•\—\\ ƒ\\•\—\\ DROP TABLE `‚s‚P`; DROP TABLE `‚s‚Q`; DROP TABLE `‚s‚R`;
¤ Dauer der Verarbeitung: 0.11 Sekunden (vorverarbeitet am 2026-10-10) ¤*© Formatika GbR, Deutschland |
|
||||||||||||||
2026-10-10