Character encoding

Hello,

I’m making a multilingual site that needs to use simplified chinese characters though when I tried
inserting the text, the preview was giving the ?? characters.

I’ve checked my modx system info and it says




Can I still change the database charset and collation charsets in MODX?

MODx is merely reporting what a query to the database returns. If System info says latin1,that’s what the actual MODx database is using.

There is a tool for converting the database to full utf-8 here: http://bobsguides.com/convert-db-utf8.html

Hi all

Thank you for your replies. It seems that I have to do BOB’s GUIDES. I hope I will not make any mistakes.
If ever, can I do it manually in phpMyAdmin? If I do it manually will there be some errors?

Cheers!

It’s *much* safer to use the script I linked to. Just export the DB first to an SQL file, then you can restore it if things go wrong, but the script I linked to shouldn’t touch your data, just its charset setting.

It’s *much* safer to use the script I linked to. Just export the DB first to an SQL file, then you can restore it if things go wrong, but the script I linked to shouldn’t touch your data, just its charset setting.

Hi,

what is the link fish? I’m getting lost with the steps of bob’s solutions because i’m still new with the database stuffs.
Does your solution a bit easy to follow and safer to do for the noobie like me?

I was thinking of doing it manually like one field to another. If I do this manually is it safe like no errors at all?

Thanks!

Hi again,

When you the bob’s script. Do I just need to download a copy of the database and run the script?
where does the php script be placed and run?

Cheers!

There’s a readme.txt file in the .zip package with step-by-step instructions.

There’s a readme.txt file in the .zip package with step-by-step instructions.

Hi Bob,

I’ve read the readme.txt already but I wasn’t able to understand them fully since I’m a newbie (sorry about this)
I haven’t handled any database manipulation or even using phpmyAdmin. I would like to take this opportunity to ask
you questions to lead me finishing this walkthrough.

Where should I run the cdc.php script? is it in local or remote? should I place it in any directory?

Cheers!

You run the cdc.php script on the local machine, but not from within MODx. Be sure to edit the first lines of it to match the local DB you created and the charset you want.
(This assumes that you’ve installed XAMPP or something similar so that you have PHP on your local machine.)

You can type php cdc.php on the command line if you have the php program in your path.

You should also be able to run it by putting it in your xampp/htdocs directory and putting http://localhost/cdc in the browser’s address window.

cdc.php sends all its output to the screen and you then cut and paste it into the SQL query box in PhpMyAdmin while working on that local DB.