Issue 785: Installation guide advises to create MySQL DB with latin1 charset
Status:  Duplicate
Merged:  issue 1273
Owner: ----
Closed:  May 2012
Reported by thkoch2001@gmail.com, Nov 26, 2010
Hi,

the current gerrit2 installation guide ( http://gerrit.googlecode.com/svn/documentation/2.0/install.html ) advises the user to create a MySQL database with latin1 charset:

ALTER DATABASE reviewdb charset=latin1;

I don't believe, that it really matters to gerrit, which charset the database has. If it does, then gerrit should support utf8.

Mar 23, 2011
#1 thkoch2001@gmail.com
I now read an explanation on the mailing list, why latin1 is indeed intended. However I wonder, if one could just have made the columns in question binary?

Subject: Re: Gerrit Install Issue.
 Date: 21.02.2011 19:07
 From: Shawn Pearce <sop@google.com>

On MySQL you have to modify the character set of the database to be
Latin1. MySQL limits indexes and unique/primary keys to be 1000 bytes,
and for UTF-8 it uses 3 bytes per character in the index rather than
1. This table (and at least one other) has too many long character
columns which may cause a valid value to be longer than the 1000 byte
limit.
May 15, 2012
#2 sop@google.com
(No comment was entered for this change.)
Status: Duplicate
Mergedinto: 1273