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

2012-01-24 Thread Ruslan Zakirov
2012/1/24 Ryo O : Hello, > Why don't you trying downgrade DBIx::SearchBuilder from 1.61 to 1.5.x You have problems with DBIx::SB 1.60+ and don't have with 1.59 and older versions. We can not reproduce problem with either. [skip] > i hope it can help you ... It can not, we tried both versions w

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

2012-01-23 Thread sunnavy
Hi Ryo I think you misunderstood, I don't have the problem but was trying to reproduce it. anyway, downgrading SB to 1.5* doesn't help reproducing this problem. sunnavy On 12-01-24 09:12, Ryo O wrote: > Why don't you trying downgrade DBIx::SearchBuilder from 1.61 to 1.5.x > > i did it like bel

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

2012-01-23 Thread Ryo O
Why don't you trying downgrade DBIx::SearchBuilder from 1.61 to 1.5.x i did it like below   -bash-3.2# cpan   cpan[1]> install RUZ/DBIx-SearchBuilder-1.56.tar.gz And Restart RT. i hope it can help you ... 2012/1/24 sunnavy : > I tested RT 4.0.4 with DBIx::SearchBuilder 1.61. > all modules are

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

2012-01-23 Thread sunnavy
I tested RT 4.0.4 with DBIx::SearchBuilder 1.61. all modules are up-to-date from CPAN. sunnavy On 12-01-23 10:29, Ryo O wrote: > I had same problem Japanese Character ( RT3.8.11 ) > > Please check DBIx::SearchBuilder version. > > DBIx::SearchBuilder version 1.56 or 1.59, i can get result of sea

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

2012-01-23 Thread Ruslan Zakirov
Hi, Which database do you use? Which version of the corresponding DBD driver is installed on your system? You can use the following commands to figure out version: perl -MDBD::mysql\ -e 1 perl -MDBD::Pg\ -e 1 perl -MDBD::Oracle\ -e 1 Use one that matches RDBMS you use. On Mon, J

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

2012-01-22 Thread Ryo O
I had same problem Japanese Character ( RT3.8.11 ) Please check DBIx::SearchBuilder version. DBIx::SearchBuilder version 1.56 or 1.59, i can get result of search Japanese character. Howerver, DBIx::SearchBuilder version over 1.6.0, i can not ger result of search Japanese character. 2012/1/21 sun

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

2012-01-21 Thread sunnavy
I failed to reproduce this on centos 5.7 with shipped perl5.8.8, and I tried both stardalone server and apache+mod_fastcgi. It would be great if there are more details of the configuration. sunnavy On 12-01-20 22:11, sunnavy wrote: > If you run RT with standalone server, is the problem still the

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

2012-01-20 Thread sunnavy
If you run RT with standalone server, is the problem still there? standalone server, I mean you start RT with something like `/path/to/rt/sbin/rt-server --port 8080` sunnavy On 11-12-29 08:53, nectar wrote: > Sir, > > Looks like can search Chinese character when use Perl 5.10 instead of > Perl

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

2011-12-28 Thread nectar
Sir, Looks like can search Chinese character when use Perl 5.10 instead of Perl 5.8.8 on CentOS 5. -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012

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

2011-12-23 Thread 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`, `TimeW

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

2011-12-21 Thread 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

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

2011-12-19 Thread nectar
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 Chine

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

2011-12-19 Thread 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

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

2011-12-19 Thread nectar
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