Transfer to Internet hosting and trouble with Russian words

[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

[admin]

Maxim,

Can you tell me if php.ini has default_charset = "utf-8" ?

Steven

[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

[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

[admin]

Maxim,

that's good news.

Where do you change the site coding?

Steven

[forgot]

Change coding on my Internet hosting provider using hosting control center web page.

[admin]

ok