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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Transfer to Internet hosting and trouble with Russian words
-
- Posts: 42
- Joined: Thu Aug 09, 2012 8:52 pm
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: Transfer to Internet hosting and trouble with Russian wo
Maxim,
Can you tell me if php.ini has default_charset = "utf-8" ?
Steven
Can you tell me if php.ini has default_charset = "utf-8" ?
Steven
-
- Posts: 42
- Joined: Thu Aug 09, 2012 8:52 pm
Re: Transfer to Internet hosting and trouble with Russian wo
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:
on hosting:
Maxim
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 |
+----------------------+-------------------+
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 |
+----------------------+-------------------+
-
- Posts: 42
- Joined: Thu Aug 09, 2012 8:52 pm
Re: Transfer to Internet hosting and trouble with Russian wo
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
After three day of searching I solved problem!
1. Update to latest nuBuilder release.
2. Change site encoding from win2151 to utf8.
Maxim
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: Transfer to Internet hosting and trouble with Russian wo
Maxim,
that's good news.
Where do you change the site coding?
Steven
that's good news.
Where do you change the site coding?
Steven
-
- Posts: 42
- Joined: Thu Aug 09, 2012 8:52 pm
Re: Transfer to Internet hosting and trouble with Russian wo
Change coding on my Internet hosting provider using hosting control center web page.