Hi, I'm not sure this mailing list is the best place to discuss further that topic, I guess you'll get more feedback on http://forums.mysql.com/ if you want to keep going in the collation direction, or on django-users.
Anyway, on that 'ś' problem, you should know more or less the full list of polish characters and their english counterpart you want to have equality for. I suggest you do some tests using different built-in collations (utf8_general_ci, utf8_unicode_ci, utf8_polish_ci, cp1250_general_ci, cp1250_polish_ci, etc.) to see if one of those matches exactly your needs. Well, there might also be none. But in that case, there's a straightforward solution, just define your own collation. In MySQL 5 you don't need to recompile if you want to add a new collation based on utf8_unicode_ci. Have a look at those links : http://forge.mysql.com/w/images/b/b7/HowToAddACollation.pdf http://dev.mysql.com/doc/refman/5.0/en/adding-collation-unicode-uca.html http://unicode.org/reports/tr35/ Then you can keep tables text field in a 'regular' polish collation, but use the custom one for search queries. -- Clément 2009/5/6 pbzRPA <[email protected]>: > > Hi, > > Thanks for the advice, it has solved some of my problem but the "ś" > for example still does not get found when looking for "s". > > But it's a step in the right direction. :) > > Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
