1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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ů
    SEMrush
     
    postcd, Dec 2, 2017 IP
    SEMrush