Arabic

This is in my header:


... and you can see my settings above.

As I wrote above: "As character set, I chose utf-8 and as collation "utf8-unicode-ci", but I can see in phpmyadmin that all collations for my ModX database default in "latin1_swedish_ci"." [ed. note: etelka1 last edited this post 11 years, 7 months ago.]

It looks as if I would never get a satisfying answer.

What should I do? Abandon ModX?

This is not a problem with MODx. It is a problem with your database configuration. If you do not know how to configure your database to have utf8 as its default character set and collation, contact your hosting tech support for help.

The database tables contain some data fields set by MODX that also need to be changed/reset to utf8. I recently had to do this in a new db. Look within each table, and if you can browse it then check each row. There are a lot of individual rows that will need to be fixed.

I found that the easiest way was to check each row from a table that needed resetting, then edit them all at once. In phpMyAdmin.

I am very thankful to you, Frogabog, that you try to help me.

The problem is not utf-8 but the collation. I cannot change it from latin1_swedish_ci to for instance utf8_unicode_ci. Did you find a way to do this?

Yes, I did. It took a couple hours though, so prepare for it. :~}

I had to use phpMyAdmin to access each table. You have to check both the structure of the table, and the table data itself. Check the table for anything set to latin1_swedish and change it. You have to look everywhere, in each row.

Edit: Are you asking about how to edit a field in phpMyAdmin?
[ed. note: frogabog last edited this post 11 years, 7 months ago.]

That's really a big job! I am also using phpMyAdmin (with ovh as a hoster) and tried it with a few tables, but after reloading the collation defaults in latin1_swedish_ci.

Check your database user permissions from the control panel. Sounds like you don't have full permissions.

Sorry, to have to ask this, but where can I check these database user permissions? Which control panel?
N.B.- I created the website and therefore also the database.

Can you log into your host, and access a control panel where you can do things like create email addresses and other nifty stuff for your server?

It's where you'd find the file manager for your server.