Charset iso unsupported ?

i have migrate from 1.0.12 to 1.0.14 ... but the charset is not correct on the new version.
my setup :
Language -> French (not the utf8 one)
charset encoding -> Western Europe (ISO)-iso-8859-1
My template encoding : iso-8859-1

my trouble is with accents of course,
when i save a ressource title with "& eacute;", i get "& eacute;" in menus
when i save a ressource title with "é", i get "é" in menus

of course i was having the same setup in previous version 1.0.12

What have i done wrong ?
[ed. note: homer8173 last edited this post 9 years, 7 months ago.]

Pls check your server settings and especially your mysql settings. This is called collation, and what happens is that the mysql database tables will be set to latin/swedish and this is probably your problem. You have a little bit of a unique situation, so I can't say definitively, but certainly your database tables have to the right collation (language settings), otherwise you can have problems.

HTH my friend. Let us know if you still have issues.

Just to be clear, any language settings <<on top of>> the database tables will get you absolutely nowhere if them tables are set wrong

i tried to set the database collation utf8-general-ci -> No change
i tried to change it on a menutitle field utf8-general-ci -> No change too

what am i supposed to set on the database ?

same thing on the table collation, no change.

but i m supposed to deliver iso-8859-1 html files, it seems normal to have DB setup on latin1_swedish_ci, no ?

Sorry, i was busy with my 5 years old son, Thanks for your help

i m confused with that issue, it was working fine in previous version.
Hopefuly i have a test server

Oh I should be clear, once the tables are made you have to change them by hand, changing the settings is too late. Its a bit of a pain to do, BobRay has explained it here:

http://bobsguides.com/convert-db-utf8.html

This thread might be useful too, just because it talks about setting up the tables. Don't worry about the bug they were talking about, its a really old thread. If you can re-migrate from a backup.

http://forums.modx.com/thread/17060/question-about-changed-database-character-set-collation

Opengeek is an important person, he says:

Set up the database before installing with the collation you want to use, then select that collation during installation.

Thanks for your suggestions but my modx is linked to many includes files in iso-8859-1, my modx must run in iso, i can't convert 100000 files behind ....

I was hoping that you had a backup of your site before you upgraded. Then you could set up MySQL with the right collation and avoid this problem (hopefully) by migrating a second time from backup.

But this is the database tables, not the files, I don't know how many tables that would be. As I know its hard but can be done, and one table probably handles many files, so it won't be so very many tables. So number of files doesn't really matter, its the number of tables.