关于使用Go语言插入数据乱码的问题

[imbrin1122]

Version : doris-2.1.4-rc02
本地mac环境，使用docker启动的服务，下载的是 apache-doris-2.1.4-bin-arm64 版本

uname -a
Darwin local 23.4.0 Darwin Kernel Version 23.4.0: Fri Mar 15 00:19:22 PDT 2024; root:xnu-10063.101.17~1/RELEASE_ARM64_T8112 arm64

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';

建表sql：

CREATE TABLE users (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
    "replication_num" = "1",
    "in_memory" = "false"
);

实例代码：

package main

import (
	"fmt"
	"log"

	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)

/*
CREATE TABLE users (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
    "replication_num" = "1",
    "in_memory" = "false"
);
*/

type User struct {
	ID   uint   `gorm:"primaryKey"`
	Name string `gorm:"type:varchar(255);not null"`
}

func main() {
	// 数据库连接信息 charset=utf8mb4
	dsn := "username:password@tcp(127.0.0.1:9030)/dbname?charset=utf8mb4&parseTime=True&loc=Local"

	// 初始化 GORM DB
	db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
	if err != nil {
		log.Fatalf("failed to connect database: %v", err)
	}

	// 插入数据
	user := User{Name: "中文测试"}
	if err := db.Create(&user).Error; err != nil {
		log.Fatalf("failed to insert user: %v", err)
	}

	fmt.Println("Insert successful")

	// 查询所有数据
	var users []User
	if err := db.Find(&users).Error; err != nil {
		log.Fatalf("failed to query users: %v", err)
	}

	// 打印查询结果
	for _, u := range users {
		fmt.Printf("ID=%d, Name=%s\n", u.ID, u.Name)
	}
}

[ixzc]

中文问题，建议去ask.selectdb.com去问问题