Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Trac: Users

Search in Trac - unicode + case sensitive

 

 

Trac users RSS feed   Index | Next | Previous | View Threaded


ukubuku at gmail

Oct 14, 2009, 1:53 PM

Post #1 of 2 (392 views)
Permalink
Search in Trac - unicode + case sensitive

Using 0.11.5: If I try to search in trac for some terms in english -
then search system works as case-insensitive.
If I try to do same for other languages (Cyrillic) - then search works
as case-sensitive.

I tested same cases on http://trac.edgewall.org/, but there it works
same case-insensitive for all languages which is correct - working in
right way.
I there already existing fix, or it is some kind of system settings or
it is some python issue?

Just would like to know the direction where to look in.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---


remy.blank at pobox

Oct 14, 2009, 2:20 PM

Post #2 of 2 (364 views)
Permalink
Re: Search in Trac - unicode + case sensitive [In reply to]

Uku Buku Babaka wrote:
> I tested same cases on http://trac.edgewall.org/, but there it works
> same case-insensitive for all languages which is correct - working in
> right way.

This is directly related to how the database backend implements the LIKE
operator. I assume you were using SQLite for your tests, which works as
follows (http://www.sqlite.org/lang_expr.html):

The LIKE operator is case sensitive for unicode characters that are
beyond the ASCII range.

OTOH, t.e.o is running PostgreSQL, where we use the ILIKE operator
(http://www.postgresql.org/docs/8.2/static/functions-matching.html):

The key word ILIKE can be used instead of LIKE to make the match
case-insensitive according to the active locale.

-- Remy
Attachments: signature.asc (0.19 KB)

Trac users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.