Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

搜索界面图标中文乱码 #14

Open
xuzevin opened this issue Jul 26, 2024 · 2 comments
Open

搜索界面图标中文乱码 #14

xuzevin opened this issue Jul 26, 2024 · 2 comments

Comments

@xuzevin
Copy link

xuzevin commented Jul 26, 2024

用 docker 安装的 mysql 是5.7
搜索界面图标显示乱码
image

管理界面里热门标签也是中文乱码
image

应用的图标能正常显示中文
image

@tsxcw
Copy link
Owner

tsxcw commented Jul 26, 2024

您好,前台是应为默认数据在文件里面所以正常,后台是因为都是在数据库,可能您的数据库字符编码设置的不正确,非uft8的,一般这种情况出现在mysql5.7的版本中,在mysql8.0或者使用宝塔在安装的mysql是不会出现这种问题,您可以试着修改一下数据库的字符编码,然后重新安装试一下。

@xjpz
Copy link

xjpz commented Oct 17, 2024

install.sql下部分建表语句没指定字符集,比如plugins_todo_folder表,
create table if not exists plugins_todo_folder ( id int auto_increment, primary key (id) ) comment 'todo分类';

而有一些表有指定字符集 ,

create table if not exists setting ( keys varchar(200) not null primary key ) character set utf8mb4 collate utf8mb4_general_ci;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants