备份和还原后的blob文本

Question

Updated Question :

I had one old script with mysql 5.5.46 . i was storing my text in one columnt with blob type. my text was persian like this : سلام خوبی جه خبر . after some month's i changed blob column to longblob column with phpmyadmin with gui(without any converting query). everything work's correctly but i get backup from my mysql and restored this db after 2 years. now it's not show my persian characters correctly.english text is ok but persian text's is going someting like the hex i mentioned in my question. I need text's stored in page_about and page_contact columns in this table: Creating Table :

    mysql_query("CREATE TABLE `".$prefix."ProFolio_info` (
                      `id` int(5) NOT NULL auto_increment,
                      `page_about` blob NOT NULL,
                      `page_contact` blob NOT NULL,
                      PRIMARY KEY  (`id`)
                    ) TYPE=MyISAM AUTO_INCREMENT=1") or die(mysql_error());

Updating Data :

$info_query = mysql_query("SELECT * FROM ".$prefix."ProFolio_info ORDER BY id DESC LIMIT 0,10");

   while($info_row = mysql_fetch_array($info_query)){
        $about_page = html_entity_decode($info_row['page_about']);
        $contact_page = html_entity_decode($info_row['page_contact']);

    if(isset($_POST['change_settings']) && $LOGGEDIN == 'yes'){

    $new_aboutpage = clean_page($_POST['about_page']);
    $new_contactpage = clean_page($_POST['contact_page']);


    if($about_page != $new_aboutpage){
        mysql_query("UPDATE ".$prefix."ProFolio_info SET page_about = '$new_aboutpage' WHERE id = '$info_id'");
    }
    if($contact_page != $new_contactpage){
        mysql_query("UPDATE ".$prefix."ProFolio_info SET page_contact = '$new_contactpage' WHERE id = '$info_id'");
    }

get texts from DB :

 <textarea name="contact_page"><? echo str_replace('<br />', '', $contact_page); ?></textarea> 
 </div>

i tested some query like cast and convert and convert column to longtest but result is the same and i have wrong chracters.

I think it stored with latin1 collation but I select column with utf-8

HEX

BC28620264F736C6173683B26756D6C3B264F736C6173683B26736563743B265567726176653BC284264F736C6173683B26736563743B20265561637574653B266D6163723B265567726176653BC281264F736C6173683B266F7264663B265567726176653BC28520264F736C6173683B26736563743B2655636972633BC28C265567726176653BC286264F736C6173683B266E6F743B264F736C6173683B26736563743B20265567726176653BC286265567726176653BC2852655636972633BC28C265561637574653B266D6163723B265567726176653BC286264F736C6173683B266E6F743B265567726176653BC28720264F736C6173683B26736563743B265567726176653BC285264F736C6173683B26736563743B20265567726176653BC285264F736C6173683B26737570333B265567726176653BC286265561637574653B26636F70793B265567726176653BC28720265561637574653B266D6163723B265567726176653B

i uploaded my script in github also uploaded script in my server and sending text from script but data going to db correctly ! i think it's just because of my backup of database. you can check my ready script from here and view my text's from kave note's menu;

Answer 1

I have too got the same problem the main reason is windows uses different kind of character encoding for different characterset. I have found the package convert character set. It has solved my problem and it may solve your too.