4images Forum & Community

4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: invisible211 on March 15, 2006, 01:53:08 PM

Title: Problemy s kodirovkoi v MySql 5.
Post by: invisible211 on March 15, 2006, 01:53:08 PM

tut vot pishut:

Quote

V novyh versiyah MySQL (nachinaya s 4.1.0) izmenilsya poryadok raboty s natsional'nymi kodirovkami, poetomu staryi kod mozhet vyzyvat' poyavlenie v tablitse bazy dannyh znakov voprosa '????????' vmesto russkogo teksta. Dlya togo, chtoby etogo ne voznikalo v nachalo PHP-skripta, posle ustanovki soedineniya s bazoi dannyh, sleduet pomestit' sleduyuschie stroki:

Code: [Select]

<?php   
  mysql_query ("set character_set_client='cp1251'");   
  mysql_query ("set character_set_results='cp1251'");   
  mysql_query ("set collation_connection='cp1251_general_ci'");   
?>

Vopros takoi kuda vstavlya t' eti stroki ya tak ponyal v fail db_mysql.php, no ya nesel v php programmirovanii i kuda by ne vstavil vsegda vylaziet oshibka sintaksisa. Pomogite. chto delat'?

Title: Re: Problemy s kodirovkoi v MySql 5.
Post by: invisible211 on March 16, 2006, 10:49:58 AM

Ну что помочь никто не может?

Title: Re: Problemy s kodirovkoi v MySql 5.
Post by: Lesik on June 11, 2006, 09:10:32 PM

Quote from: invisible211 on March 15, 2006, 01:53:08 PM

tut vot pishut:

Quote

V novyh versiyah MySQL (nachinaya s 4.1.0) izmenilsya poryadok raboty s natsional'nymi kodirovkami, poetomu staryi kod mozhet vyzyvat' poyavlenie v tablitse bazy dannyh znakov voprosa '????????' vmesto russkogo teksta. Dlya togo, chtoby etogo ne voznikalo v nachalo PHP-skripta, posle ustanovki soedineniya s bazoi dannyh, sleduet pomestit' sleduyuschie stroki:

Vopros takoi kuda vstavlya t' eti stroki ya tak ponyal v fail db_mysql.php, no ya nesel v php programmirovanii i kuda by ne vstavil vsegda vylaziet oshibka sintaksisa. Pomogite. chto delat'?

аналогичная фигня - кто нибудь поможет пребороть недуг

Title: Re: Problemy s kodirovkoi v MySql 5.
Post by: V@no on June 11, 2006, 09:17:35 PM

Можно попробовать вставить в includes/db_mysql.php над

Code: [Select]

    return $this->connection;
вот это:

Code: [Select]

    mysql_query ("set character_set_client='cp1251'", $this->connection);
    mysql_query ("set character_set_results='cp1251'", $this->connection);
    mysql_query ("set collation_connection='cp1251_general_ci'", $this->connection);