We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
JumpServer 更改过一次数据库的校对集,已满足搜索区分大小写的问题,后来觉得不区分大小写才是通用的方案,后来的还原了,这个改变是在于创建数据库时指定的默认校对集,utf8_bin 区分大小写,utf8_general_ci (通常这个是默认)是不区分的
mysql> show create database jumpserver; +------------+--------------------------------------------------------------------------------------+ | Database | Create Database | +------------+--------------------------------------------------------------------------------------+ | jumpserver | CREATE DATABASE `jumpserver` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ | +------------+--------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)
然而有时候我们想做转换,搜索时想区分大小写:
$ mysqldump -uroot -h127.0.0.1 -p jumpserver > jumpserver.sql
$ mysqldump -uroot -h127.0.0.1 -p --opt -d jumpserver > jms_opt.sql
$ mysqldump -uroot -h127.0.0.1 -p -t jumpserver > jms_data.sql
sed -i 's@CHARSET=utf8;@CHARSET=utf8 COLLATE=utf8_bin;@' jms_opt.sql
mysql > DROP DATABASE jumpserver; mysql > CREATE DATABASE jumpserver DEFAULT CHARSET utf8 COLLATE utf8_bin;
$ mysql -uroot -h127.0.0.1 -p jumpserver < jms_opt.sql $ mysql -uroot -h127.0.0.1 -p jumpserver < jms_data.sql
$ mysqldump -uroot -h127.0.0.1 -p jumpserver > jumpserver.sql $ cp jumpserver.sql jumpserver.sql.$(date '+%Y-%m-%d_%H:%M:%S')
$ sed -i 's@COLLATE=utf8_bin@@g' jumpserver.sql $ sed -i 's@COLLATE utf8_bin@@g' jumpserver.sql
mysql > CREATE DATABASE jumpserver_v2 DEFAULT CHARSET utf8;
$ mysql -uroot -h127.0.0.1 -p jumpserver_v2 < jumpserver.sql
$ vim /opt/jumpserver/config/config.txt DB_NAME=jumpserver_v2 $ ./jmsctl.sh restart
The text was updated successfully, but these errors were encountered:
No branches or pull requests
JumpServer 更改过一次数据库的校对集,已满足搜索区分大小写的问题,后来觉得不区分大小写才是通用的方案,后来的还原了,这个改变是在于创建数据库时指定的默认校对集,utf8_bin 区分大小写,utf8_general_ci (通常这个是默认)是不区分的
然而有时候我们想做转换,搜索时想区分大小写:
更换为 utf8_bin 校对集
还原为 utf8_general_ci 校对集
The text was updated successfully, but these errors were encountered: