[rt-users] cannot get result of search Chinese character - centos 5.4

[Kevin Falcone]

On Tue, Dec 20, 2011 at 01:30:53AM +0800, nectar wrote:
> Sir,
> 
> Installed RT4.0.4 on CentOS 5.4 box, make new database from RT or
> restore mysql file, everything looks well. But cannot get result of
> search Chinese character.
> 
> For example, if ticket subject is "Best Practical 公司", then we can
> search "Best" or "Practical" to list this ticket, but "公司" get no
> result.
> 
> I tried to install old version of FCGI(from 0.74 to 0.68), but still
> the same issue.
> 
> refer: Centos 5.4 + FCGI + Unicode in messages = Failure -
> http://www.gossamer-threads.com/lists/rt/users/92359

Were you getting Wide character in the logs?  Downgrading FCGI is
unlikely to do anything other than cause problems with RT4.0.4

What is the actual query being run, against what raw Subject field
from the database that you expect to match on?

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20111219/0cc606b9/attachment.sig>