Printable View
Hi,
I am working on my russian web site now and It will be completely russian site(no choice of language), admin is in english. The problem is: I can't find php editor, that would show me russian characters. Everything is working perfectly fine in browser, but to edit things, I don't see characters...I use Vista English as my local PC. Tried around 7 editors, that suppose to work with rtf-8 codes, but nothing works, I get this:
Äèñêîíòíûå êàðòî÷êè
Any help will be appreciated...
TIA
And second issue that I faced is I can't get into admin now. I get blank page:-(I just installed Russian as default language and Russian currency, nothing else. As I mentioned before , Russian is only in includes/languages/ ,not in admin...
And another thing I have problem with is if I write russian letters in a description of the product when I add new product into catalog, I get ????? instead of letters. Is there and issue with coding in database? Maybe someone knows how to change it in phpmyadmin?
TIA
Hi,
I am working on my russian web site now and It will be completely russian site(no choice of language), admin is in english. The problem is: I can't find php editor, that would show me russian characters. Everything is working perfectly fine in browser, but to edit things, I don't see characters...I use Vista English as my local PC. Tried around 7 editors, that suppose to work with rtf-8 codes, but nothing works, I get this:
Äèñêîíòíûå êàðòî÷êè
And second issue that I faced is I can't get into admin now. I get blank page:-(I just installed Russian as default language and Russian currency, nothing else. As I mentioned before , Russian is only in includes/languages/ ,not in admin...
And another thing I have problem with is if I write russian letters in a description of the product when I add new product into catalog, I get ????? instead of letters. Is there and issue with coding in database? Maybe someone knows how to change it in phpmyadmin?
TIA
Ms_X
Ms,
Take a look at this tutorial page to read:
Or the beauty of Zen Cart is look at the Cache Folder in the root directory to find the error log...
thanks for response, I have read tute...I am attching an image where read shows that some words are translated ok, some(green) not. I tried all types of charsets,at the moment:
@setlocale(LC_TIME, 'ru.utf8');
define('CHARSET', 'windows-1251');
if i change charset to utf-8, everything is translated to some symbols...I did not create database using utf-8 codding in this case. I have done a new instalation though using this tutorial:
srw2d.com/sites/default/files/utf-8-zen-cartV1.3.8.pdf
But could not change code in query factory, when i changed the code, instalation process did not work...In this case nothing is translated at all even though I have changed everywhere setlocale and charset.I use latest zencart version...:-(
here is the image
Today I started all new again. Here what I did:
1) Followed the instructions listed here http://www.srw2d.com/sites/default/f...cartV1.3.8.pdf
except of not changing the query_factory.php file but doing this:
Create a new file for it:
/includes/extra_configures/my_db_charset.php
Code:
<?php define('DB_CHARSET', 'utf-8');
2)I have followed all the instructions in the link above and verified that my site was all being sent to the browsers in UTF8, I started to install Russian language pack . After installing the language website was all looking fine and in russian. Then I decided to test if russian characters were being inserted into the database correctly, I created a test category with a russian name (in admin section) but then on the site's catalog side I see this category name listed as a bunch of ?????.
So the question is what to do now? I looked in phpmyadmin, when i see the structure of my database, all the tables collation is set to "latin1_general_ci" and at the end of the list on the last row (where one can see the number of pages) I see in collation field "utf8_general_ci"
And I wanted to ask another(a bit stupid question:-)):
the name my_db_charset.php should be written as my_db_charset.php or instead of my_db the name of my db should be written?
Thanks for replies...
Today I started all new again. Here what I did:
1) Followed the instructions listed here http://www.srw2d.com/sites/default/f...cartV1.3.8.pdf
except of not changing the query_factory.php file but doing this:
Create a new file for it:
/includes/extra_configures/my_db_charset.php
Code:
<?php define('DB_CHARSET', 'utf-8');
2)I have followed all the instructions in the link above and verified that my site was all being sent to the browsers in UTF8, I started to install Russian language pack . After installing the language website was all looking fine and in russian. Then I decided to test if russian characters were being inserted into the database correctly, I created a test category with a russian name (in admin section) but then on the site's catalog side I see this category name listed as a bunch of ?????.
So the question is what to do now? I looked in phpmyadmin, when i see the structure of my database, all the tables collation is set to "latin1_general_ci" and at the end of the list on the last row (where one can see the number of pages) I see in collation field "utf8_general_ci"
And I wanted to ask another(a bit stupid question:-)):
the name my_db_charset.php should be written as my_db_charset.php or instead of my_db the name of my db should be written?
Thanks for replies...
and another question, do I need to save any fileas as without BOM?I am so much confused now after reading a lots of posts here and trying to figure out the truth...
P.s:I am at the moment using my local PC(localhost for testing) and latest version of zencart
and another question, do I need to save any fileas as without BOM?I am so much confused now after reading a lots of posts here and trying to figure out the truth...
P.s:I am at the moment using my local PC(localhost for testing) and latest version of zencart
Be sure to do that in your /RENAMED-ADMIN/includes/extra_configures folder too!!!!!Quote:
Originally Posted by Ms_X
If you don't, then your admin activity won't be treated as utf-8.
Well, I guess that's possible if you hadn't set the /zc_install/includes/installer_params.php file to use utf-8 as well:Quote:
Originally Posted by Ms_X
I'm pretty sure you want to use "utf8", not "utf-8" when it comes to the DB_CHARSET. I think using "utf-8" would apply only in the language file.Code:<?php define('DB_CHARSET', 'utf8');
The filename doesn't matter. It could be called "fred.php" as long as the content inside is correct.Quote:
Originally Posted by Ms_X
Yes. ALL files that contain utf-8 encoding in them need to be saved as UTF8-without-BOM.Quote:
Originally Posted by Ms_X
Responded to your questions here: http://www.zen-cart.com/forum/showth...58#post1002758
Thanks a lot for your response, Dr. Byte,
I am now installing new fresh zencart using your advice and that article. I just set the /zc_install/includes/installer_params.php file to use utf-8 as well:
<?php define('DB_CHARSET', 'utf8');
and when i started intallation process of zen cart I got Bad Getway Error. But when I changed installer_params.php file back to what was there originally, I see Instalation page. Any suggestions on what should I do now?:-(I guess the problem is somewhere here that my russian characters displayed as question marks. I am looking im Mysl forums as well to find the answer,but unfortunately no results yet:-(
Sorry for saying I could not install it before. I just restarted my server and refreshed cash. Everything installed and on web site everything is shown in russian. Database tables are all set to utf_8_general_ci. Now I have different problem:When I add category or product in russian, after i save it, it is shown on the websites catalogue site as no name product like on the attached picture...
If I write using latin alphabet then i see the names of the products...So there must be a problem with russian characters then:-(
here some setting of the russian file:
@setlocale(LC_TIME, 'ru.utf8');
....
// charset for web pages and emails
define('CHARSET', 'windows-1251');
If I change to:
define('CHARSET', 'utf-8');
I get site translated the way that i see instead of russian words the ??? inside black diamonds. When do i need to convert files to utf without bom?before insyallation or after?i did not do it yet...
I was just thinking if this problem could occur because te old version of PHP and mysql?I have MySQL 5.0.45 and PHP/5.2.4 installed...
Either is fine. Before is okay. After is okay.Quote:
Originally Posted by Ms_X
MySQL version is unlikely to be a problem.Quote:
Originally Posted by Ms_X
If you have the ability to use PHP 5.3 it might help.
Dr Byte,Quote:
Originally Posted by DrByte
Thanks a lot for your help...
I am still with the same problem :if I change russian.php file's encoding to utf without BOM, then instead of russian words on the websote i see funny characters. If I change encoding back to ANSI,everything looks fine again.:shocking:
So, when you have things set so CHARSET and LC_TIME etc are set to appropriate values for russian characters, you say you're getting garbage on the screen.
When that happens, click your browser's View menu, and look at the Character Encoding section. What's it set to?
Then click your browser's View menu and choose View Source / View Page Source. What does it say near the top for lang= and charset= ?
DrByte, I have done the my_db_charset.php suggestion both on the admin and catalog side. However, the admin is still showing the question mark symbol � instead of ™. The changes to english.php have also been done, database updated to utf8_general_ci, etc. Everything on the catalog side is showing as expected.
So, which piece is not UTF8 then? Lang file? Database content? Browser display?