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
pgpDXzJf5PXVQ.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
