25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
import { describe, expect, it } from "vitest";
import type { QueryResult } from "@/types/database";
import { mysqlTableCollationSql, parseMysqlTableCharset, parseMysqlTableCollation } from "@/lib/table/mysqlTableCollation";
function result(columns: string[], rows: QueryResult["rows"]): QueryResult {
return { columns, rows, affected_rows: 0, execution_time_ms: 1 };
}
describe("mysqlTableCollation", () => {
it("builds mode-independent lookup SQL for quoted and Unicode names", () => {
const sql = mysqlTableCollationSql("db'x", "订单\\archive");
expect(sql).toContain("TABLE_COLLATION AS table_collation");
expect(sql).toContain("TABLE_SCHEMA = CONVERT(X'64622778' USING utf8mb4)");
expect(sql).toContain("TABLE_NAME = CONVERT(X'e8aea2e58d955c61726368697665' USING utf8mb4)");
expect(sql).not.toContain("db'x");
});
it("reads the reported collation regardless of column-name casing", () => {
expect(parseMysqlTableCollation(result(["TABLE_COLLATION"], [["utf8mb4_0900_ai_ci"]]))).toBe("utf8mb4_0900_ai_ci");
expect(parseMysqlTableCollation(result(["table_collation"], [[" utf8mb4_bin "]]))).toBe("utf8mb4_bin");
});
it("falls back to no table default when the server reports nothing usable", () => {
// MySQL reports TABLE_COLLATION as NULL for views, and the lookup itself may fail.
expect(parseMysqlTableCollation(result(["table_collation"], [[null]]))).toBe("");
expect(parseMysqlTableCollation(result(["table_collation"], []))).toBe("");
expect(parseMysqlTableCollation(result(["engine"], [["InnoDB"]]))).toBe("");
expect(parseMysqlTableCollation(undefined)).toBe("");
});
it("derives the table charset and collation from the same metadata row", () => {
expect(parseMysqlTableCharset(result(["TABLE_COLLATION"], [[" utf8mb4_0900_ai_ci "]]))).toEqual({
charset: "utf8mb4",
collation: "utf8mb4_0900_ai_ci",
});
expect(parseMysqlTableCharset(result(["table_collation"], [[null]]))).toEqual({
charset: "",
collation: "",
});
});
});