[rt-users] 3.0.9, Perl 5.8.3, and UTF-8 problem still

[Dmitry Monakhov]

I have the same problem with with searching russion utf8 character!
I'm using Mysql 4.0.16, perl 5.8.3, apache 1.3.27+mod_perl

Toni Mueller wrote:
> 
> Hello,
> 
> I've got a problem finding tickets with accented characters. To test,
> I've generated a ticket with a subject containing my last name,
> "Müller". When searching it, I get the correct display in the web page
> search mask, namely
> 
> Status = open [delete]
> Subject LIKE müller [delete]
> Status = new [delete]
> 
> But I don't find the ticket. This is what I find in the query log
> (PostgreSQL 7.4.1 on Debian unstable for the whole thing including the
> browser):
> 
> Mar  2 16:12:23 spruce postgres[4294]: [16-1] LOG:  statement: SELECT count(main.id) FROM Tickets main WHERE ((main.EffectiveId
> Mar  2 16:12:23 spruce postgres[4294]: [16-2]  = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (main.Subject ILIKE '%m\203ller%') ) AND (
> Mar  2 16:12:23 spruce postgres[4294]: [16-3]  (main.Status =
> 'open')OR(main.Status = 'new') ) ) 
> 
> 
> Sorry, this is garbled. The string around ILIKE above reads like this in
> Emacs hexl-mode:
> 
> 00000130: 6d61 696e 2e53 7562 6a65 6374 2049 4c49  main.Subject ILI
> 00000140: 4b45 2027 256d c35c 3230 33c2 bc6c 6c65  KE '%m.\203..lle
> 00000150: 7225 2729 2029 2041 4e44 2028 0a4d 6172  r%') ) AND (.Mar
> 
> Or, with od:
> 
> 1776600   e  sp   =  sp   '   t   i   c   k   e   t   '   )   )  sp   A
> 1776620   N   D  sp   (  sp   (  sp   (   m   a   i   n   .   S   u   b
> 1776640   j   e   c   t  sp   I   L   I   K   E  sp   '   %   m   C   \
> 1776660   2   0   3   B   <   l   l   e   r   %   '   )  sp   )  sp   A
> 1776700   N   D  sp   (  nl   M   a   r  sp  sp   2  sp   1   6   :   1
> 1776720   2   :   2   3  sp   s   p   r   u   c   e  sp   p   o   s   t
> 
> 
> My database is configured to have a standard encoding of UNICODE.
> 
> If I search for a string with no accented characters, I find the
> ticket(s) no problem.
> 
> 
> TIA!
> 
> 
> 
> Best,
> --Toni++
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
Dmitry Monakhov System Administrator
Open Technologies, tel: +7(095)787-7027
e-mail: monakhv at ot.ru, http://www.ot.ru/