Zen Cart Logo
Forums / General Questions / russian chars dosnt show

russian chars dosnt show

Locked

Views: 3,003

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
7 Oct 2006, 11:07 AM
#1
maxus avatar

maxus

Zen Follower

Join Date:
Feb 2005
Location:
Prague
Posts:
130
Plugin Contributions:
0

russian chars dosnt show

I mean it is bag.
I make update from 1.3. to 1.3.5 and cant write russian in categories description.

For exclude my foult I make new installation and set 3 languages.
Set russian language in admin zone - edit CHARSET
When Im use charset like iso-8859-1 system show me only first 3 letters of russian word. It is standart situation - I see it in 1.2.7 cose I need to use right (russian) charset.

When Im set russian charset windows-1251 and put Categories description in russian - system dosnt put any letters to descriptions. Just see empty description field.

HTML cource show <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">

If I edit categorie name directly in database - categorie name look like "Категори тесС"

Server OS: FreeBSD 6.1-RELEASE-p3
Database: MySQL 5.0.22

7 Oct 2006, 12:11 PM
#2
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: russian chars dosnt show

Yes. It's a bug. Your bug. I use 1.3.5 with russian chars without ANY problem.

When you "edit categorie name directly in database" you use utf-8.

7 Oct 2006, 12:38 PM
#3
maxus avatar

maxus

Zen Follower

Join Date:
Feb 2005
Location:
Prague
Posts:
130
Plugin Contributions:
0

Re: russian chars dosnt show

ha ha. really funny...
Im dont need edit it in DB directly.... I need edit it in admin zone.

Need solution or help where I need to search problem

7 Oct 2006, 4:01 PM
#4
maxus avatar

maxus

Zen Follower

Join Date:
Feb 2005
Location:
Prague
Posts:
130
Plugin Contributions:
0

Re: russian chars dosnt show

DONE

Im find solution on czech forum

Need ot add code to query_factory.php file
after line 38
mysql_query("set names cp1251");

It is worked for me

8 Oct 2006, 11:25 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: russian chars dosnt show

Thanks for the update on this ... :smile:

24 Dec 2006, 12:22 AM
#6
michael101 avatar

michael101

New Zenner

Join Date:
Jul 2004
Posts:
30
Plugin Contributions:
0

Re: russian chars dosnt show

Hello Maxus
i tryed your solution without success
here is what i have from line 1 to 54 in /includes/classes/db/mysql/query_factory.php :

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers                           |
// |                                                                      |
// | [url]http://www.zen-cart.com/index.php[/url]                                    |
// |                                                                      |
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | [url]http://www.zen-cart.com/license/2_0.txt[/url].                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
// $Id: query_factory.php 1279 2005-05-01 21:01:37Z drbyte $
//


class queryFactory {

  function queryFactory() {
    $this->count_queries = 0;
    $this->total_query_time = 0;
  }

  function connect($zf_host, $zf_user, $zf_password, $zf_database, $zf_pconnect = 'false', $zp_real = false) {
//@TODO error class required to virtualise & centralise all error reporting/logging/debugging
    $this->database = $zf_database;

    // pconnect disabled
    if (!$zf_pconnect == 'false') {
      $this->link = @mysql_connect($zf_host, $zf_user, $zf_password);
    } else {
      $this->link = @mysql_connect($zf_host, $zf_user, $zf_password);
    }
    if ($this->link) {
      if (@mysql_select_db($zf_database, $this->link)) {
        $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;
    }
  }

Any Idea ?

Thanks

Michael

30 Apr 2008, 10:43 AM
#7
crazybrat avatar

crazybrat

New Zenner

Join Date:
Apr 2008
Posts:
13
Plugin Contributions:
0

Re: russian chars dosnt show

i tried too, doesn't work in my files :(