Project

General

Profile

Bug #16453

Weblate MariaDb has the wrong charset

Added by emmapeel 10 days ago.

Status:
Confirmed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
02/10/2019
Due date:
% Done:

0%

QA Check:
Dev Needed
Feature Branch:
Type of work:
Sysadmin
Blueprint:
Starter:
Affected tool:
Translation Platform

Description

today intri noticed that the weblate database has a weird charset for something about localisation ( latin1 )

In the weblate docs ( https://docs.weblate.org/en/latest/admin/install.html?highlight=charset%20database#unicode-issues-in-mysql ) it says that the charset should be `utf8mb4`:

ALTER DATABASE weblate CHARACTER SET utf8mb4;

But "Using this charset might however lead to problems with the default MySQL server settings, as each character now takes 4 bytes to store, and MySQL has an upper limit of 767 bytes for an index. In case this happens you will get one of the following error messages:

  • 1071: Specified key was too long; max key length is 767 bytes
  • 1709: Index column size too large. The maximum column size is 767 bytes.

And there are some workarounds that should be evaluated.

Also available in: Atom PDF