56,820
社区成员




DROP TABLE IF EXISTS `codetable`;
CREATE TABLE `codetable` (
`id` int(11) DEFAULT NULL,
`gb` varchar(1) DEFAULT NULL,
`big` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16;
-- ----------------------------
-- Records of codetable
-- ----------------------------
INSERT INTO `codetable` VALUES ('1', '万', '萬');
这个是function
BEGIN
SELECT Replace(__str, big, gb) INTO __str
FROM codetable
WHERE locate(big, __str) > 0;
RETURN __str ;
END
Parameter __str varchar(200) charset utf16