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

[Kevin Falcone]

On Tue, Dec 20, 2011 at 03:53:23PM +0800, nectar wrote:
> kevin,
> 
> a. search from RT as "http://domain/Search/Simple.html?q=中文",  RT got:
> Found 0 tickets
> b. search database using SQL as "SELECT * FROM  `rt4`.`Tickets` WHERE
> ( `Subject` LIKE  '%中文%' )", database got: Showing rows 0 - 0 (1
> total, Query took 0.0003 sec)
> 
> Does it mean that we can search Chinese character from sql query, but
> can not from RT web page?

Please turn on $StatementLog in your config and capture the actual
query that RT runs.  We'd also need to see the actual Subject line
stored in the Tickets table.

-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/20111221/e01d3b2e/attachment.sig>