Use utf8 charset for searchindex MySQL table
authorKevin Israel <pleasestand@live.com>
Thu, 26 Sep 2013 05:38:02 +0000 (01:38 -0400)
committerKevin Israel <pleasestand@live.com>
Thu, 26 Sep 2013 06:02:52 +0000 (02:02 -0400)
commit2f02c77b4ef1d6a7d6a8e8862ead5592863d7988
tree8799954cc111c4165f4e31cb8b775aa742b664bb
parent123d4122c84f4078de080046a1d2a4981dcdf4d7
Use utf8 charset for searchindex MySQL table

This prevents the DB error "1283 Column 'si_title' cannot be part of
FULLTEXT index", which happens when the "binary" charset is used.

Note that 2ab7c9ec3b fixed the problem for creation of new DBs, though
not for reuse of existing DBs. It is still necessary to specify the
character set for the table itself.

Bug: 47191
Change-Id: Ib4f30fd2730839af1323295898e6dce47b27068d
RELEASE-NOTES-1.22
maintenance/tables.sql