Character Set Problem with Special Characters

[moscato]

hello,

i hope somebody can help me with my character-set problem.

i've installed CMSMS with collation: utf8_unicode_ci.

when in use special characters in my content area everything seems to work fine. in the admin- and front-end the characters are displayed correctly.

but when i switch to phpmyadmin and go to the table "cms_content" the characters are not displayed correctly. this is very confusing. does anybody know how to solve this problem. what have i done wrong?

please find two screenshots attached. one with an example of the confusing caracters (it should be "five €" and not as it is in the screenshot). as additional information please find a screenshot of my mysql settings...

thanks a lot for your help!

best regards,
tom

[Pierre M.]

Hello tom,

i've installed CMSMS with collation: utf8_unicode_ci.

when in use special characters in my content area everything seems to work fine. in the admin- and front-end the characters are displayed correctly.

CMSms is doing fine ? great !

but when i switch to phpmyadmin and go to the table "cms_content" the characters are not displayed correctly. this is very confusing. does anybody know how to solve this problem. what have i done wrong?

PhpMyAdmin is doing wrong ? You should ask its support, not CMSms'.

Pierre M.

[hugosnel]

Hello,

I did not installl unicode 8 ...
The page title will not show special characters.
It should read:
De la mer à  l'assiette Poissonnerie Clément UZES
at my testsite:
http://meatwork.info

Any ideas? all welcome!

[Pierre M.]

Hello,

your post lacks version/context information at least. See http://forum.cmsmadesimple.org/index.ph ... 661.0.html

Pierre M.

[hugosnel]

Got it!

I'm running CMS Made Simple 1.4. I'm using PHP 4.4.1, and MySQL 5.1.6 This is all working with Apache 2.2.4 running on Linux
with Mysql  5.0.27.

The database is configures by the server standard as "latin1_swedish_ci"

I am setting up a site in the french language and want the tiltel to be :

De la mer à  l'assiette Poissonnerie Clément UZES

it becomes:

De la mer �  l'assiette Poissonerier Cl�©ment UZES

I have gone through the fields in the data base and corrcted them mannually but the title will not show up correct.
TIA

[Pierre M.]

Workaround quick try : De la mer à l'assiette Poissonnerie Clément UZES
You should check all the web chain for character encoding : client os, browser, webserver, php, db driver, database/engine, server os. For example, about webserver : check http headers and httpd.conf

Pierre M.

[hugosnel]

I did , nogo. It is probably in the database.
However :After switching to another template it (mycuisine) it is ok!
Thanx!