MySQL bad characters: všech světových parfémů

Discussion in 'Site & Server Administration' started by postcd, Dec 2, 2017.

  1. #1
    Hello,

    please can You tell me is wrong, i transfered my site from server with:
    PHP 5.3.3, mysql 5.5.58-cll
    to:
    PHP 5.3.29, 10.0.33-MariaDB

    The website started showing damaged texts, like: vÅ¡ech svÄ›tových parfémů (on the site it should appear like: všech světových parfémů - it is czech language)
    Original/source server MySQL collation and row content is same (same strange characters). So i assume mysql and files are same.

    MySQL server:
    MySQL MYISAM table collation: utf8_unicode_ci
    MySQL column type: longtext, collation: utf8_unicode_ci
    MySQL rows contains texts like: všech světových parfémů

    The page, where the "damaged" text appears has this in source code: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    The file that makes connection to mysql contains:
    define('LANGUAGE', 'cs');
    define('DB_DRIVER', 'mysql');
    define('DB_HOST', 'localhost');

    I googled and found a few articles
    https://stackoverflow.com/questions/7861358/strange-characters-in-database-text-Ã-Ã-¢-â-€
    https://stackoverflow.com/questions/5232344/convert-latin1-to-utf8

    in aim to discover how to convert my database, but i am unsure. Please can you suggest what may work?MySQL bad characters: všech světových parfémů
     
    postcd, Dec 2, 2017 IP