Page 1 of 1
Transfer to Internet hosting and trouble with Russian words
Posted: Wed Aug 29, 2012 3:17 pm
by forgot
Hello.
I try transfer nuBuilder from local server to Internet server and find following issue with Russian letter - On Internet server all Russian words are appeared like "Города".
In my local server all are good.
Local Server - Use wamp - Apache - 2.2.22 PHP - 5.3.13 and MySQL - 5.5.24
Internet Server - Web hosting with Apache - 1.3.37 PHP - 5.2.10 and MySQL - 5.1.41-log
1. I create backup of DB using myphpadmin
2. Create DB on Internet Server using myphpadmin
3. Restore backup using myphpadmin
4. Copy all file from local to remote
5. Change config.php for connecting to remote MySQL.
After that when I log to nuBuilder all Russian words are appeared like "Города" (strange hieroglyphs).
If I use remote myphpadmin for seeing remote db all row good - Characters readable.
Encoding of tables and columns are same - utf8_general_ci.
In remote server works two web site bases on Joomla engine.
So I believe it isn't issue of nuBuilder but please tell me that I doing wrong.
Maxim
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Thu Aug 30, 2012 6:02 am
by admin
Maxim,
Can you tell me if php.ini has default_charset = "utf-8" ?
Steven
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Thu Aug 30, 2012 8:22 am
by forgot
Not. Neither php.ini on local server or on hosting server doesn't have this line. default_charset isn't defined.
All this time searching why this happened. So find something different in MySQL variables. But if I change them as on local server problem with hieroglyphs still appeared.
I am new in PHP and MySQL (or other DB) and my knowledge very poor. All that I did then create nuBuilder site and transfer it to hosting base on default settings and default wizard.
On local:
Code: Select all
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+-----------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------+
| character_set_client | cp866 |
| character_set_connection | cp866 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | cp866 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | c:\wamp\bin\mysql\mysql5.5.24\share\charsets\ |
+--------------------------+-----------------------------------------------+
8 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'collation%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | cp866_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
on hosting:
Code: Select all
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+--------------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------------+
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | cp1251 |
| character_set_server | cp1251 |
| character_set_system | utf8 |
| character_sets_dir | /.ro/usr/local/mysql/share/mysql/charsets/ |
+--------------------------+--------------------------------------------+
8 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'collation%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | cp1251_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | cp1251_general_ci |
+----------------------+-------------------+
Maxim
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Fri Aug 31, 2012 11:29 am
by forgot
Ho-ho!
After three day of searching I solved problem!
1. Update to latest nuBuilder release.
2. Change site encoding from win2151 to utf8.
Maxim
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Mon Sep 03, 2012 5:38 am
by admin
Maxim,
that's good news.
Where do you change the site coding?
Steven
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Mon Sep 03, 2012 10:07 am
by forgot
Change coding on my Internet hosting provider using hosting control center web page.
Re: Transfer to Internet hosting and trouble with Russian wo
Posted: Wed Sep 05, 2012 2:34 am
by admin
ok