Hello,
I'm trying to install the last server version(1.1.0) from source on debian buster.
Compilation was ok but i have problem with db creation.

mysql report an error with index limitation: "Specified key was too long; max key length is 1000 bytes"
mysql version: Ver 15.1 Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

There is a workaround for this?
Thanks!

---

There's no definitive fix, but it's a known problem - some discussion and suggestions in #2140.

Also an external reference to StackOveflow: https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

Hi!
Thank you for your very quick answer!

I try one of the simplest solution i found on your stackoverflow link.

1/ delete current database
2/ manually create database with 'latin1_general_ci" encoding.
3/ import db/schema.sql and db/constraints.sql

This can successfully create database, but is this a good thing to have the db in 'latin1_general_ci'
Is this not make new issue with daemons and web pages expecting utf8 db?
Thanks!

---

It depends what you're planning to use the database for. If it's for private, in-house usage only, and you can control exactly what's written into it, then you could be fine.

But if it's facing an international public audience, then you have to use a character set which can handle everything which is being thrown at it, currently up to 4-byte emojis. I was sent a PM here yesterday, which appeared to contain ðŸ‘�: it turned out to be a simple 👍. You've probably seen some curious versions of your (accented) name over the years.

Further discussion of the character sets used in an international setting at #2117.

It's for private use in my university (Lille - France) to provide researchers computing resources with computer lab.
So it could be fine :-)
Thank you!

---

It's in general not a good idea to start a DB with latin1 nowadays. Tis is one thing you can't easily change afterwards. The problem on Debian buster is that they use utf8mb4 as the default whereas BOINC just needs utf8 to work correctly. So if you still can please change to UTF8 (without the mb4).