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