DB Version: 10.0.20-MariaDB
Export of functions and procedures simply writes the DB directives to generate the same CHARACTER_SET_CLIENT, CLIENT_CONNECTION and DATABASE_COLLATION, but not the definition of the function itself:
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Versione server: 10.0.20-MariaDB-log - MariaDB Server
-- S.O. server: Linux
-- HeidiSQL Versione: 9.2.0.4947
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;