2009/5/5 pbzRPA <[email protected]> > > Hi, thank you for your input. > > The trouble I am having is that I have a polish database of users with > polish letters in their names and surnames. Now not all international > users have access to polish letters on their system therefore I need > to be able to let a user enter English letters like "L" in there > search and the search results should include all the polish names with > "Ł" in them. This was why I was thinking of writing an operator that > calls a function in the database to convert the letters on the run. >
Hi, Depending on the database engine you're using, it could be way easier to rely on collations to solve your problem. Check out this link ( http://bugs.mysql.com/bug.php?id=9604 ) if you're running MySQL; regarding the 'Ł' and 'L' equality in polish and general unicode collations. Seems like cp1250_general_* is the only one comparing all polish characters 'correctly' to their english equivalent. Hope that helps, -- Clément --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/django-developers?hl=en -~----------~----~----~----~------~----~------~--~---
