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