https://project.math.uzh.ch/
https://project.math.uzh.ch/favicon.ico?1666878389
2021-02-16T10:16:43Z
Project @ iMath
QFQ - Feature #12023: MySQL Stored Precdure: QDECODESPECIALCHAR()
https://project.math.uzh.ch/issues/12023?journal_id=47974
2021-02-16T10:16:43Z
Carsten Rose
carsten.rose@math.uzh.ch
<ul></ul><pre>
DELIMITER $$
CREATE DEFINER = `root`@`localhost` FUNCTION `QDECODESPECIALCHAR`(x longtext)
RETURNS longtext
NO SQL
DETERMINISTIC
BEGIN
DECLARE TextString LONGTEXT;
SET TextString = x ;
SET TextString = REPLACE(TextString, '&amp;','&') ;
SET TextString = REPLACE(TextString, '&quot;','"') ;
SET TextString = REPLACE(TextString, '&#039;',"'") ;
SET TextString = REPLACE(TextString, '&apos;',"'") ;
SET TextString = REPLACE(TextString, '&lt;','<') ;
SET TextString = REPLACE(TextString, '&gt;','>') ;
RETURN TextString ;
END$$
DELIMITER ;
</pre>
QFQ - Feature #12023: MySQL Stored Precdure: QDECODESPECIALCHAR()
https://project.math.uzh.ch/issues/12023?journal_id=47976
2021-02-16T10:21:06Z
Carsten Rose
carsten.rose@math.uzh.ch
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-5 priority-2 priority-default closed" href="/issues/12022">Feature #12022</a>: New escape class: htmlSpecialChar</i> added</li></ul>