On Tue, Oct 28, 2008 at 10:54 AM, DULMANDAKH Sukhbaatar < [EMAIL PROTECTED]> wrote:
> > > Use search_fields = ['name'] in the corresponding > > class inside admin.py > > I did. Actually my text is Cyrillic. Just now I tested searching > sample latin or english text, and search workin fine. Is it problem > with non-english text? if so how i can fix it, and make work? > > Django's case-insensitive search is going to map to a LIKE query for sqlite. According to this page: http://www.sqlite.org/lang_expr.html sqlite doesn't handle case-insensitive searches for anything except 7-bit ASCII: "(A bug: SQLite only understands upper/lower case for 7-bit Latin characters. Hence the LIKE operator is case sensitive for 8-bit iso8859 characters or UTF-8 characters. For example, the expression *'a' LIKE 'A'*is TRUE but *'æ' LIKE 'Æ'* is FALSE.)." So it sounds like you will need to move to a different DB if you want case-insensitive searching to work for Cyrillic chars. Karen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
