Kevin, Thanks for your reply.
Same database, from Debian box is okay, but CentOS 5.4 is not. Here it sql file: INSERT INTO `Tickets` (`id`, `EffectiveId`, `Queue`, `Type`, `IssueStatement`, `Resolution`, `Owner`, `Subject`, `InitialPriority`, `FinalPriority`, `Priority`, `TimeEstimated`, `TimeWorked`, `Status`, `TimeLeft`, `Told`, `Starts`, `Started`, `Due`, `Resolved`, `LastUpdatedBy`, `LastUpdated`, `Creator`, `Created`, `Disabled`) VALUES (1, 1, 1, 'ticket', 0, 0, 6, '中文测试 - test - 123abc', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 14:02:47', 12, '2011-12-20 14:02:47', 0), (2, 2, 1, 'ticket', 0, 0, 6, '中文测试2', 0, 0, 0, 0, 0, 'new', 0, NULL, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 12, '2011-12-20 15:51:25', 12, '2011-12-20 15:51:24', 0); Here it is from rt.log(Debian): [debug]: SQL(0.167067s): SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%中%') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.id ASC LIMIT 50; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Here it is from rt.log(CentOS): [debug]: SQL(0.000729s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Subject LIKE '%涓?') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1064) Thanks, -- Jia -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
