Want to change all group names to lower case.

The database was originally initialized with case insensitive collation and yet some groups have mixed case names. This is really messing with my queries for groups as I am trying to make a move feature. I would like to simply lower case all group names in the database. This probably won’t cause any issues other than perhaps re sign into some of your groups. If it does cause issues, they can be dealt with. I think this is a better solution than putting in a bunch of hacky code for a few existing groups when future groups will all be lower case anyway. I am sure we can handle incoming url’s to existing mixed case names just by lower casing them on input so any old url’s out there should still work.

Any major reason you can think of not to?

Tags

  1. groups
  2. group names

Comments


Seth says
seth 2016-01-18 13:14:50 [item 19699#42741]
sounds good to me yes … but the upper-lower case URLs that might be hyperlinking from elsewhere will still resolve correctly .. right?
seth 2016-01-18 13:16:28 [item 19699#42743]
dA 2016-01-18 13:23:23 [item 19699#42745]
Yes. They still go through missing.php and can be lower cased right at the start of all the code.
like

Holmes says

Done.


See Also

  1. Thought Group on Politics with 12 viewings related by tag "groups".
  2. Thought FastBlogIt Common Stream with 7 viewings related by tag "groups".
  3. Thought about: Lawrence Krubner with 5 viewings related by tag "groups".
  4. Thought How can i log into an anonymous group to edit items or delete goofy tags? with 4 viewings related by tag "groups".
  5. Thought swhack with 3 viewings related by tag "groups".
  6. Thought Golden Rule with 2 viewings related by tag "groups".
  7. Thought how everyone can have their own advatar here ... with 1 viewings related by tag "groups".
  8. Thought Domain groups with 1 viewings related by tag "groups".
  9. Thought Black River Blog with 1 viewings related by tag "groups".
  10. Thought dev - the fastblogit development group with 1 viewings related by tag "groups".
  11. Thought Information about the FastBlogIt domain with 1 viewings related by tag "groups".
  12. Thought A list of groups that i frequent ? with 0 viewings related by tag "groups".
  13. Thought About Speak To Me Catalog with 0 viewings related by tag "groups".
  14. Thought add groups to the live search with 0 viewings related by tag "groups".
  15. Thought Wants & Needs with 0 viewings related by tag "groups".
  16. Thought Rooms and People ... Tags and Names with 0 viewings related by tag "groups".
  17. Thought the Identity Web vs mutually resonant entities with 0 viewings related by tag "groups".
  18. Thought The Evil Geniuses of Marketing with 0 viewings related by tag "groups".
  19. Thought Test and QA with 0 viewings related by tag "groups".
  20. Thought about: group Cheng Hsin - developed to Peter Ralston with 0 viewings related by tag "groups".
  21. Thought header pictures are broken in group tag rooms with 0 viewings related by tag "groups".
  22. Thought References to reserved groups with 0 viewings related by tag "groups".
  23. Thought journal of jason with 0 viewings related by tag "groups".
  24. Thought Sending Invitations with 0 viewings related by tag "groups".
  25. Thought about: strange attractors in human behavior - google search with 0 viewings related by tag "groups".
  26. Thought Making it easier to switch groups with 0 viewings related by tag "groups".
  27. Thought Hi I Am anony-mouse with 0 viewings related by tag "groups".
  28. Thought What is a joy stream ? with 0 viewings related by tag "groups".
  29. Thought tags and group names with 0 viewings related by tag "groups".
  30. Thought Comment spam may be our biggest challenge early on with 0 viewings related by tag "groups".
  31. Thought group quads project with 0 viewings related by tag "groups".
  32. Thought Test and QA with 0 viewings related by tag "groups".
  33. Thought Automatic group selection with 0 viewings related by tag "groups".
  34. Thought Distinguishing the common river, from tag rooms, from group rooms by colors ? with 0 viewings related by tag "groups".
  35. Thought A Quick Blurb with 0 viewings related by tag "groups".
  36. Thought If you edit an item, it pushes it out into the river again. with 0 viewings related by tag "groups".
  37. Thought Group Listing with 0 viewings related by tag "groups".
  38. Thought Winnie with 0 viewings related by tag "groups".
  39. Thought I think group names need to be a better managed resource with 0 viewings related by tag "group names".
  40. Thought Philosophy Group with 0 viewings related by tag "groups".
  41. Thought The Funny Pages with 0 viewings related by tag "groups".
  42. Thought Empty Tag Rooms vs Item private to group xxxxx with 0 viewings related by tag "groups".
  43. Thought Agile Processes with 0 viewings related by tag "groups".