Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Character set problem with MySQL export/import
Update: I exported the textpattern table from the old server, and deleted the textpattern table on the new server. Imported from the old server as-is, without changing anything.
Then, checked the textpattern varchar etc. latin1_swedish_ci. OK. Then, ran your plugin, which changed everything to UTF8.
Checked the page, and all looked good except for a few characters here and there (category lists and prefs in the Admin prefs > basic).
Changed the config.php dbcharset from Latin1 to UTF8. Same as above.
In the diagnostics on the new server I have this:
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_filesystem: binary
character_set_results: utf8
character_set_server: utf8
character_set_system: utf8
character_sets_dir: /opt/mysql/mysql-5.0.41-solaris10-x86_64/share/mysql/charsets/
18 Tables: OK
The 18 tables Ok is new. Before, it just listed each table as UTF8, but no error reported.
Offline
Re: Character set problem with MySQL export/import
This is… confusing. Well, at least it works now, so that’s good.
Offline