Hello, Thanks for pointing the point, I agree by finding people strugling too with this problem and having also utf8mb4 encoding. But now I set the database variable as follow and I still have the same issue.
+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec)
+----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+
ERROR 1071 (42000) at line 436: Specified key was too long; max key length is 767 bytes
Do I need to do something else?
Regards Guillaume
On 6 July 2018 at 14:22, Nicky Gerritsen nickygerritsen@me.com wrote:
Hi Guillaume,
Please don’t forgot to add the devel list in your mails.
For your question: I’m not entirely sure. I think you can configure it using the MySQL server configuration.
Regards,
Nicky
On 6 Jul 2018, at 13:59, Guillaume MILAN guillaumilan@gmail.com wrote:
Hi Nicky Is it possible to change the mysql default collation? To be able to create the domjudge data base with the correct collation?
Regards, Guillaume
Le 6 juil. 2018 13:09, "Nicky Gerritsen" nickygerritsen@me.com a écrit :
Hi Guillaume,
This might happen with specific MySQL collations. If I remember correctly either utf8 or utf8mb4 has this issue and the other doesn’t.
Regards,
Nicky
On 6 Jul 2018, at 13:04, Guillaume MILAN guillaumilan@gmail.com wrote:
Hello while I launch the dj_setup_database executable, I receive the following error.
*ERROR 1071 (42000) at line 436: Specified key was too long; max key length is 767 bytes*
Do you know what can create this error?
Regards Guillaume
DOMjudge-devel mailing list DOMjudge-devel@domjudge.org https://www.domjudge.org/mailman/listinfo/domjudge-devel