mysql将数据库与gbk编码连接
发布时间:2025-06-24 18:59:58 作者:北方职教升学中心 阅读量:546
问题原因
编码不一致sql脚本文件utf8编码,Mysql默认用gbk编码连接数据库。mysql将数据库与gbk编码连接。
2024-07-02 09:16:56.902 - IO error: Process failed (exit code = 1). See error log.2024-07-02 09:16:56.902 - java.io.IOException: Process failed (exit code = 1). See error log. at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:263) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:241) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:283) at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:87) at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)。解决方案:
在执行脚本时添加额外的命令参数:--default-character-set=utf8。问题原因:

编码不一致sql脚本文件是utf8编码默认情况下,