[rt-users] search case sensitiv

[Curtis Bruneau]

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 
sorting.

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
>