latin1_swedish_ci?

I have phpMyAdmin installed and I took a look at the tables in my MODx database and the entire "Collation" column is set to "latin1_swedish_ci." The phpMyAdmin main page shows "MySQL charset: UTF-8 Unicode (utf8)" and has the "MySQL connection collation:" dropdown menu set to "utf8_unicode_ci." I’m not even certain of what collation exactly is -- but swedish seems a little strange. So what the heck ...am I set up correctly or not? Thanks for your response.

Collation has to do with sorting and ordering. The "swedish" thing is standard Western European collation.

http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html

Susan, thanks for the reply. So then -- I’ll assume you’re saying that the Swedish setting is the correct setting for a proper MODx installation for someone in the US like me. If I’m assuming incorrectly, please let me know. Thanks again.

Quote from: bullrat at Sep 17, 2006, 11:43 AM

Susan, thanks for the reply. So then -- I’ll assume you’re saying that the Swedish setting is the correct setting for a proper MODx installation for someone in the US like me. If I’m assuming incorrectly, please let me know. Thanks again.

That’s just the default MySQL collation on many installations and MODx uses whatever the default collation sequence for the connection to the db is. In other words, if your database is created, and the default collation sequence for that db is latin1_swedish_ci, you’ll have case-insensitive sorting and searching on varchar/*text columns. If you want another encoding simply change the default collation for that database, or your entire MySQL installation. I typically change my default collation sequence to utf8_general_ci, because I prefer to work with data stored in utf8, but this is really a decision dependent on the content requirements of your site (and potentially limited by your installation/configuration of MySQL).