Project

General

Profile

Bug #16453

Weblate MariaDb has the wrong charset

Added by emmapeel 7 months ago. Updated 5 months ago.

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

50%

Spent time:
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.

History

#1 Updated by groente 6 months ago

  • Assignee changed from groente to emmapeel
  • % Done changed from 0 to 50
  • QA Check changed from Dev Needed to Ready for QA

changed the charset and didn't notice anything broken - can you confirm and close the ticket if all is well?

#2 Updated by emmapeel 5 months ago

  • Status changed from Confirmed to Resolved
  • QA Check changed from Ready for QA to Pass

looks good!

Also available in: Atom PDF