[rt-users] search case sensitiv

Curtis Bruneau curtisb at vianet.ca
Fri Nov 14 16:49:33 EST 2008

I'm guessing you are using utf8_bin collation, the others are case 
insensitive. Unfortunately non binary utf8 ones aren't accent sensitive 
so it lacks a bit compared to latin1 which offers both. If accents 
aren't a major concern you should be using like utf8_unicode_ci or 
utf8_general_ci or swedish .. they all have slightly different rules for 

Bjoern Schulz wrote:
> Hi RT Users.
> after upgrading to 3.8.1 the search for ticket content is case sensitiv.
> To solve this problem (for us) any hint would be appreciated.
> Best regards
>    Björn
> System.
> SL5 (RHEL5)
> mysql 5.0.45
> perl 5.8.8
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

More information about the rt-users mailing list