Tango controls, create_db.bat error

Tango controls, create_db error

Tango控制，创建数据库时发生错误。

D:\Program Files\tango\share\tango\db>create_db.bat
Enter password: ****
ERROR 1071 (42000) at line 257 in file: ‘create_db_tables.sql’: Specified key was too long; max key length is 1000 bytes

create_db.bat内容：

@ECHO OFF

rem IF NOT DEFINED MYSQL_USER (
rem	mysql -e "\. %TANGO_ROOT%\share\tango\db\create_db.sql"
rem	GOTO SCRIPT_END
rem )

rem mysql -u%MYSQL_USER% -p%MYSQL_PASSWORD% -e "\. %TANGO_ROOT%\share\tango\db\create_db.sql"
mysql -u root -p -e "\. %TANGO_ROOT%\share\tango\db\create_db.sql"
:SCRIPT_END

mysql 版本：

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 8.0.16 MySQL Community Server – GPL

修改mysql字符集为utf8，即可解决问题。

my.ini中：

default-character-set=utf8

character-set-server=utf8