Re: [mantisbt-dev] Bug 9216

[David H. <hic...@op...>]

I've patched it so that the default collation is set to utf8_general_ci
regardless of what your MySQL installation defaults to. See
http://dev.mysql.com/doc/refman/6.0/en/charset-server.html for
information on how it is possible for a MySQL to not use utf8_general_ci
as the default collation for the utf8 character set.

In my opinion, if you are letting Mantis create your database, you
probably don't want to know anything about collations, so it'd be best
to use a generic default of utf8_general_ci that favours performance
over accuracy.

You may be installing Mantis (for an English development community) on a
server in Sweden that has a MySQL default collation of utf8_swedish_ci.
It seems safer to me to use utf8_general_ci in all cases unless the user
says otherwise (by manually creating the database themselves).

For the future I think it might be a good idea to add some installation
documentation that covers database collation settings and how they
impact Mantis behaviour. Or possibly a script in admin/ that allows
users to update their Mantis database to use different collation
settings?

David


On Tue, 2009-06-23 at 03:12 -0700, Sir Shurf Lonely-Lockly wrote:
> Hi all.
> 
> 
> I have checked the latesed night build, and can see that bug 9216 is
> still not fixed, thought marked resolved.
> 
> 
> I have added a comment on it, how I fixed it currenlty.
> 
> 
> sincerely
> 
> 
>  
> Alex Frenkel
> Web Aplication Developer, 
> IM: 79536239 (AIM)
> http://www.linkedin.com/in/sirshurf
> 
> "If you want something done right,
> you have to do it yourself."
> 
>              mobile: 972 54 5918887
> 
> 
>                                    
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> Are you an open source citizen? Join us for the Open Source Bridge conference!
> Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
> Need another reason to go? 24-hour hacker lounge. Register today!
> http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
> _______________________________________________ mantisbt-dev mailing list man...@li... https://lists.sourceforge.net/lists/listinfo/mantisbt-dev