Search

Some strange troubles with encoding:

I install Symphony 2.0.7 on my home computer (Mac OS Snow Leopard). When trying save some cyrilic text I got “????” symbols.

Database encoding - UTF-8.

When I install Symphony on hosting everything works OK.

Any ideas?

It works on my Mac (Snow Leopard, Safari). I tried this:

А Б В Г Д Е Ж Ѕ З И І

Have you manually changed the browser’s encoding?

No, browser’s encoding UTF-8.

Else, when I manually edit record in database, text showing correctly.

Database encoding - UTF-8.

Even if you chose this during installation, have you checked the database server itself? It sounds like some MySQL config somewhere is latin1 and not UTF-8. Check both the server character_set and collation variables, and also the encoding type of individual database tables.

In manifest/config.php, what is the character_set and character_encoding value? Both should be utf8.

One level above this though, I’ve found that when the database is created on the MySQL server it needs to have the correct config set.

One level above this though, I’ve found that when the database is created on the MySQL server it needs to have the correct config set.

Yes!

@michael-e Yes, it’s UTF-8

If all these things are right, I have no idea what’s going wrong here. If everything in the database and in Symphony is set to UTF-8, I would assume that it’s a browser problem. Have you tried using a different browser?

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details