Package: mantis
Version: 1.1.8+dfsg-8
Severity: minor
Tags: moreinfo
thanks
On 10/25/2010 09:14 AM, Alexi F. Sharafutdinov wrote:
> During installation dbconfig-common sets latin1_swedish_ei collation
on all tables and fields in mantis database.
> This makes mantis unusible for russian speaking people because they
use cyrilic letters.
> Manualy changing collations for databese, tables and all fields to
utf8_general_ci solve this problem.
The database installation, even if you choose dbconfig-common or not,
the installation uses your current mysql-server defaults.
The default character set for the mysql-server-5.1 package is currently
latin1.[1] There are more notes about this issue on package mysql-server
documentation.
Please, can you verify the ouput of this commands from your mysql-server:
$ mysqladmin variables |grep character
$ mysqladmin variables |grep collation
The mantis database will be set using the defaults of your mysql-server.
If you want to install your mysql databases on other collation settings,
there are some ways to avoid this: changing manually the collation of
your database (as you did) or changing the defaults of your mysql-server
(my.cnf) to prevent similar situations.
Please, let me know if this is your case.
I downgrade this bug to minor, because is not completely unusable to
everyone. [2]
Thanks for your time and collaboration,
Sils
[1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=438970
[2] http://www.debian.org/Bugs/Developer#severities
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
