Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages? Chapter 2. Using Admin Tools, Changing your database collation)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?Chapter 2. Using Admin Tools, Changing your database collation, https://www.akeebabackup.com/home/news/56-releases/1074-admintools-2-0.html About the bug fix: "Changing the database prefix and collation would not work on MySQL 4.1 hosts. Disabled these features for MySQL versions earlier than 5.0.")? Yes
Joomla! version: (5.2.9)
PHP version: (5.3.13)
MySQL version: (5.1.66-cll-lve)
Host: (oderland.se)
Admin Tools version: (2.4.4)

Info from phpMyAdmin:

DATABASE SERVER
Server: Localhost via UNIX socket
Software: MySQL
Software version: 5.1.66-cll-lve - MySQL Community Server (GPL) (Cloud Linux Jan 17 2013 09:52:24)
Protocol version: 10
User:
Server charset: UTF-8 Unicode (utf8)

WEBSERVER
cpsrvd 11.34.1.7
Database client version: libmysql - 4.1.22
PHP extension: mysql Documentation

Description of my issue:

In AT when trying to use "Change Database Collation" I select utf8_swedish_ci and then I press Apply. I get the confirmation message "Database collation changed" but the dropdown selection menu has popped back to utf8_general_ci again and also when I browse the site, menu with alphabetical order I can confirm that it hasn't worked. Also in phpMyAdmin it says utf8_general_ci under Server connection collation and also for all the tables in the database.

What do you think I'm doing wrong? I'd so much prefer to use the AT feature to change the collation from utf8_general_ci to utf8_swedish_ci because I really don't know exactly what I'm doing when in phpMyAdmin :-)

Yes, I understood that utf8_general_ci is default but after I've selected utf8_swedish_ci and pressed Apply I do get the confirmation message that it has changed (please see the screen shot attached) but at the same time it pops back to utf8_swedish_ci by itself.

I just called my host and they say there are no restrictions for me to change my own databases (collation or otherwise). In fact they also tried it because they had AT installed as well. They tried it on 2 different Joomla installs and the same thing happened at their side...

Also, I do have my db user configured with all previleges (please see the screen shot attached).

Sorry about this Nicholas :-) Would you have any more suggestions?

Oh, for once in my life ! :-)

OK, I've installed Admin Tools version rev87AACD3. Now the articles are sorted in the right order, even with Swedish characters å ä ö !

Then my intention was to confirm this by checking in phpMyAdmin... And that's weird (at least to me) cause as far as I can se it says utf8_general_ci in every table except down at the bottom in the "Sum row" where it says utf8_swedish_ci. I attached a screen shot again in case...

But maybe it should be like that. Anyway the sorting of articles on the website works fine now :-)

So this was also my first time installing an alpha. When you have released the stable I can just upgrade as usual "on top of" that one, right?

Aha, I definitely need to learn about MySQL databases (I'm a complete novice :-)

Thank you so much for fixing this issue. I was thinking it's weird that nobody missed this feature (and discovered the bug) for so long but I think that many users of AT just have no idea about all the features available... I've just started to discover (and dare to use :-) several of them lately and I'm so so pleased!

Greetings