Problem with my encoding ! How to resolve ?

[ersinhakera]

I have got a problem with my encoding on site, because i`m writing on Bulgarian (cyrilic). To resolve problem, i`m asked in bulgarian forum for my problem. They answered me, giving the following code :

Code: [Select]

mysql_query("SET CHARACTER SET cp1251");
mysql_query("SET NAMES cp1251"); and say me to put them in config.php . If anybody make this for me I`don`t know in who files, and where in the files to put them. 

This must be put before <?php : 

Code: [Select]

<meta http-equiv="content-type" content="text/html; charset=windows-1251">These codes after

Code: [Select]

<?php:  iconv_set_encoding("internal_encoding", "windows-1251"); 
iconv_set_encoding("output_encoding", "windows-1251"); 
iconv_set_encoding("input_encoding", "windows-1251"); 
iconv_set_encoding("all", "windows-1251");And after every query they say me to put this code :

Code: [Select]

mysql_query("SET CHARACTER SET cp1251");
Pls help me with examples, or directly with ready files 

[ersinhakera]

Nobody knows? 

[V@no]

Let's start from the beginning. Please tell us what 4images version do you use and what kind of problem you have.

[Anya]

I have the same problem, all russian words are displayed like this ���. (Version 1.7.6 )
everything worked fine when I tested the gallery on my local server (Windows OS), but now it is installed on another server (which is not Windows one and the encoding is not windows-1251 by default). I think I need to paste some code into the .php file related to the database, but i'm not sure.
Can you help me?

Thanks

[V@no]

Try add into .htaccess:

Code: [Select]

AddDefaultCharset windows-1251

[alekinna]

Before installation open the file data/database/default/mysql_default.sql
and replace each

Code: [Select]

TYPE=MyISAM;
with

Code: [Select]

TYPE=MyISAM CHARACTER SET=cp1251;
change cp1251 to encoding of your site


2. in the file includes/db_mysql.php

find

Code: [Select]

function Db($db_host, $db_user, $db_password = "", $db_name = "", $db_pconnect = 0) {
    $connect_handle = ($db_pconnect) ? "mysql_pconnect" : "mysql_connect";
    if (!$this->connection = $connect_handle($db_host, $db_user, $db_password)) {
      $this->error("Could not connect to the database server ($db_host, $db_user).", 1);
    }
    if ($db_name != "") {
      if (!@mysql_select_db($db_name)) {
        @mysql_close($this->connection);
        $this->error("Could not select database ($db_name).", 1);
      }
    }
    return $this->connection;
  }
replace with

Code: [Select]

function Db($db_host, $db_user, $db_password = "", $db_name = "", $db_pconnect = 0) {
    $connect_handle = ($db_pconnect) ? "mysql_pconnect" : "mysql_connect";
    if (!$this->connection = $connect_handle($db_host, $db_user, $db_password)) {
      $this->error("Could not connect to the database server ($db_host, $db_user).", 1);
    }
mysql_query ("set character_set_client='cp1251'");
mysql_query ("set character_set_results='cp1251'");
mysql_query ("set collation_connection='cp1251_general_ci'");
    if ($db_name != "") {
      if (!@mysql_select_db($db_name)) {
        @mysql_close($this->connection);
        $this->error("Could not select database ($db_name).", 1);
      }
    }
    return $this->connection;
  }
change cp1251 to encoding of your site


3. if you use cp1251 - in the file includes/search_utils.php

find

Code: [Select]

$val = convert_special($val);
replace with

Code: [Select]

// $val = convert_special($val);
3.a if you use utf8 -  in the file includes/search_utils.php

find

Code: [Select]

function convert_special($text) {
  return strtr(
    $text,
    array(
      "Ä" => "AE",
      "Ö" => "OE",
      "Ü" => "UE",
      "ä" => "ae",
      "ö" => "oe",
      "ü" => "ue",
      "ß" => "ss"
    )
  );
}
replace with

Code: [Select]

function convert_special($text) {
  return strtr(
    $text,
    array(
      "×" => "÷",
      "Á" => "á",
      "¨" => "Å",
      "¸" => "å"
    )
  );
}
and save the file in utf-8 format

[V@no]

If I'm not mistaken, 4images doesn't care about mysql charset, it encodes any non-latin letters into HTML entities codes, which makes the text charset independent.

[Anya]

Try add into .htaccess:

Code: [Select]

AddDefaultCharset windows-1251

Thanks, everything works fine now

[Anya]

Now when I try to add a category/image description in russian, or change the category/image name to russian - it looks like this: ??????????
but the language pack works properly, all the fields are displayed in russian correctly...

[V@nо]

is that with unmodified 4images?

[Anya]

sorry, I forget to replace the file includes/db_mysql.php with unmodified one after trying to fix the previous problem with encoding. Everythink is ok  Thanks for help thou 

[790511]

Hi, I have a similar problem. After I have moved my web to new hosting and import saved database, some Czech characters are shown incorrectly in the webpage, although they are OK in phpMyAdmin. This problem is reported many times and the most frequent solution seems to be to put:

mysql_query("SET CHARACTER SET cp1250"); 
mysql_query("SET NAMES cp1250");

This is supposed to be between
mysql_connect(...);
...
mysql_select_db(...);

My question is: where could I place this piece of code in my good old 4images 1.7.4? For me it is quite hard to find it as the code is quite complicated. Thanks in advance for your kind help.