Same issue as #45501 but with Category Titles.
When you save a category with spaces, before or after the title, the spaces are saved in the database.
Ordering the Categories on Title, give confusing results with Titles that start with spaces.

Summary of Changes

This PR removes the spaces before and after the Category Title when saving the Category.

Testing Instructions

In the back-end under Content > Categories:

• create a few categories that start with different letters
• add some spaces before one of the category titles
• order the Categories on Title
• see the weird result (the title with spaces is on top)

Actual result BEFORE applying this Pull Request

(Accidental) spaces before (and after) the Category Title are saved:

The "Some categories have spaces before and after the title" starts with spaces,
which are not visible in the list of categories,
which makes it confusing that this item is listed on top.
Instead you would expect it to be listed between "All categories have titles" and "Uncategorized"

Expected result AFTER applying this Pull Request

Saving works well, the spaces before and after the title are trimmed (removed from the title) :

Ordering looks good:

Link to documentations

Please select:

• Documentation link for docs.joomla.org:

• No documentation changes for docs.joomla.org needed

• Pull Request link for manual.joomla.org:

• No documentation changes for manual.joomla.org needed