Đang Thực Hiện

161495 MySQL charset encoding problem


NB - pls ignore this project if you havn't expirience in that and don't know how to fix this problem.

I'm programmer too and havn't time to fix this problem.

We prefer RUSSIAN speaker freelances!

We have one of our sites that using cp1251 character encoding and we have issue with cron task.

We have script that get news through rss and store into database.

Site is [url removed, login to view]

Script that get rss news [url removed, login to view]

Script that remove rss news [url removed, login to view]

Page, there you will see imported rss news [url removed, login to view];category=pressuz

When we run this script [url removed, login to view] to get rss news manually - news importing and storing into database fine. But then we run this script through cron task - characters storing wrong into database. Some times news text stored fine sometimes no.

I'm confused and don't know what to do.

After connecting to database we run below queries to change charset :

mysql_query("SET NAMES 'cp1251' ");

mysql_query("SET collation_connection='cp1251_general_ci'");

mysql_query("SET collation_server='cp1251_general_ci'");

mysql_query("SET character_set_client='cp1251'");

mysql_query("SET character_set_connection='cp1251'");

mysql_query("SET character_set_results='cp1251'");

mysql_query("SET character_set_server='cp1251'");

I don't understand why when script running by cron task - charset changing not working.

Please help me decide this problem

Happy Bidding :)

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: sites freelances, site freelances, programmer bidding sites, index php cat, freelances site, freelances is not working, freelances in, freelances database, freelances sites, www freelances, speaker russian, russian speaker, mysql index, FREELANCES, freelances c, encoding, cat character, mysql characters, mysql running, php encoding, character problem, mysql script help, cron mysql, ignore text php, php cron task

Về Bên Thuê:
( 7 nhận xét ) Utrecht, Uzbekistan

ID dự án: #1907684