在迁移过程中遇到自定义函数调用的问题:CREATE OR REPLACE FUNCTION ADM."ISDATE" (str in varchar2)return numberisdt date;len number(2);begin /* if str is null then return 1; end i...(more)
mysql导出数据,导成Excel格式,发现中文乱码,数据库字符集为utf-8,Excel字符集为GB2312,SELECT * INTO OUTFILE '/tmp/20150709/sys_role.xls' FROM sys_role;网上查了,有说用convert(label using gb2312)转,报错 ERROR 1115 (42000): Unknown character set: 'gb2312'SELECT id,...(more)