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

[nectar]

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