Category Name - only four letters showed?

[urbanlife]

Hi there,

I have installed zen cart and three additional language packages (Bulgarian, German and Russian). As I tryed to translate the name of one Category in Cyrrilic, only the first 4 letters are showed, the rest is cut, while the description of the categorie works pretty well. The names of categories written in latin letters work.
I tryed to change other names, like color options for some products, but there I have the same problem - only 4 letters in Cytillic.

Where go the other Letters?

Thanks!
Martin

[urbanlife]

Hi there,

I have installed zen cart and three additional language packages (Bulgarian, German and Russian). As I tryed to translate the name of one Category in Cyrrilic, only the first 4 letters are showed, the rest is cut, while the description of the categorie works pretty well. The names of categories written in latin letters work.
I tryed to change other names, like color options for some products, but there I have the same problem - only 4 letters in Cytillic.

Where go the other Letters?

Thanks!
Martin

[lazy_666]

Hello there, i have been thru all this in the pas week, the problem is mostly in encodings.
here what i have done since my store is brand new, and still is not released.
i converted all of tables in database in utf8_general_ci
then got Uni2Me.exe (encoding convertor) and converted all Bulgarian files in utf-8,
in /includes/languages/XXXXXX.php where XXXXXX stands for names you using (I use Englsih, Russian, Bulgarian and Turkish) find the line wirh CHARSET definition and replace windows-1251 with utf-8 for bg and ru
and in english Iso-8859-1 to utf-8.
then in you have to add 2 lines in
/includes/classes/db/mysql/query_factory.php

//@TODO error class required to virtualise & centralise all error reporting/logging/debugging
    $this->database = $zf_database;
    if (!function_exists('mysql_connect')) die ('Call to undefined function: mysql_connect().  Please install the MySQL Connector for PHP');
    if ($zf_pconnect != 'false') {
      $this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
    } else {
    // pconnect disabled ... leaving it as "connect" here instead of "pconnect"
      $this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
    }
    if ($this->link) {
      if (@mysql_select_db($zf_database, $this->link)) {
        mysql_query("SET NAMES UTF8;");
        $this->db_connected = true;
        return true;
      } else {
        $this->set_error(mysql_errno(),mysql_error(), $zp_real);
        return false;
      }
    } else {
      $this->set_error(mysql_errno(),mysql_error(), $zp_real);
      return false;
    }
  }

Then, (asuming u got translation for version 1.3.0 from official website download directory) u should get WinMerge and compare all files in /includes/language/XXXXX directory one by one (trust me i know what i am writing)
basicaly ... most problems will be in Bulgarian.php, meta_tags.php, login.php and index.php (at least those were my problems).
another thing u should reconsider .... use Notepad++ for editing, and if one file is not marked as ANSI as UTF-8 get other file wich have that encoding, and copy - paste content then save as. That might look lame for experts... but it works at least for me.
if u get blank pages.... well i did that: got english.php then replaced every translated statement, keep in mind if u think to do that to copy ONLY text inside and not ' (dunno the name of that symbol)
if some definitions are missing, i could recomend u to add them to the files so people see english text instead of NAME_OF_THE_SHOP

from now on, your newly added product should be fine (old ones will be a mess)
u might need to do same thing for adimn area too, cuz some files have to display its contents in Bulgarian.


OR

u can just simply walk thru database and increase every VARCHAR variable to 255 ;) wich is simplest solution but.... u might not like results.

I hope that helps.
Thanks in beers

[hlubach]

I try too understand what you wrote but i cannot figure it out .

I downloaded uni2me and find the file russian.php in /includes/languages/russian.php
Do i start a conversion without changing the mentioned
line wirh CHARSET definition and replace windows-1251 with utf-8 for bg and ru
and in english Iso-8859-1 to utf-8.
Or do i change the file and then choose utf * and convert then

[lazy_666]

changing ISO-XXX thingie with UTF8 is NOT for conversion purposes but for the site.
So, when Zen-Cart read that file, it puts UTF-8 in CHARSET variable, then when it comes to generating the web pages for visitor, ZC just puts value of CHARSET in page, and then fill the page.

Those steps should help u resolve your problems.

Open file in Notepad++ (available at sourceforge.net), then do:
Format -> Convert to UTF8 without BOM (in lower right corner there SHOULD appear "ANSI as UTF8")
Save (you may skip this step)
replace ISOXXXX with UTF8
Save
Upload.

that should do the trick.

If u don't replace ISOXXX then the site will look "funny" at least, but u can experiment a little. :)

If u have more problems, post here, i will try to help.

[hlubach]

I done what you wrote except the iso part I ddo not understand witch part that is but
Is that replace the windows-1251 line in charset
But what i se are strange things
РљР°С‚РµРіРѕС this is what shows now the Category header, but the translation of other text on main page seems to be correct
It is weird al the text is shown correctly only in the Category is wil show wrong

[lazy_666]

Have you tried, to add new content? or you just observe old added content in categories?

that might offend you, but as I said...

from now on, your newly added product should be fine (old ones will be a mess)

[hlubach]

I had not done that but as i said it was the category header not the content of the category.
replace ISOXXXX with UTF8 and in what file do i change this

[hlubach]

Tried every solution described at this forum but the problem remain,
I can hardley believe that there is no solution for this problem.
Al the other translation are good so far as I can see the problem only occurs at the Category.
In the product section this problem doesn't excist

Han

[lazy_666]

give me link to the site and upload here your /includes/languages/bulgaria.php