Skip to content

java.sql.SQLException: Incorrect string value: '\xE5\xBC\x80\xE5\x8F\x91...' for column 'name' at row 1 #1

@yujunhao8831

Description

@yujunhao8831

示例程序中 dept name设置了"开发部", 如果本地的数据库不是UTF-8格式,导致中文无法插入.
检查库默认格式是否是utf8_general_ci,如果不是则删除重新创建.
CREATE DATABASE IF NOT EXISTS 你的 DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions