Project

General

Profile

Actions

Defect #14718

closed

update redmine 0.9.4 to 2.3.2 ,database encoding problem

Added by hi say over 12 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

hi,all
I have installed 0.9.4 version, now need upgrade to 2.3.2.

0.9.4 database encoding is latin1 and english version ,but content have some chinese(e:wiki)
the database default character set is latin1;
mysql> show variables like '%set%'; +--------------------------+---------- | Variable_name | Value +--------------------------+---------- | auto_increment_offset | 1 | character_set_client | latin1 | character_set_connection | latin1 | character_set_database | latin1 | character_set_filesystem | binary | character_set_results | latin1 | character_set_server | latin1 | character_set_system | utf8 | character_sets_dir | D:\PROGRA +--------------------------+---------- 9 rows in set (0.03 sec)

now update to 2.3.2 the chinese version,
the database default character set is utf8;
sql>show variables like '%set%'; +--------------------------+-------------- | auto_increment_offset | 1 | character_set_client | utf8 | character_set_connection | utf8 | character_set_database | utf8 | character_set_filesystem | binary | character_set_results | utf8 | character_set_server | utf8 | character_set_system | utf8 | character_sets_dir | G:\BitNami\RE +--------------------------+-------------- 9 rows in set (0.00 sec) mysql> show variables like '%coll%' -> ; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+ 3 rows in set (0.00 sec)
when import 0.9.4 database to 2.3.2 database ,all the contents of the database cannot be displayed on the home page.

get some can't read character.

Actions #1

Updated by hi say over 12 years ago

hi,all
I have installed 0.9.4 version, now need upgrade to 2.3.2.

0.9.4 database encoding is latin1 and english version ,but content have some chinese(e:wiki)
the database default character set is latin1;

mysql> show variables like '%set%';
+--------------------------+----------
| Variable_name            | Value
+--------------------------+----------
| auto_increment_offset    | 1
| character_set_client     | latin1
| character_set_connection | latin1
| character_set_database   | latin1
| character_set_filesystem | binary
| character_set_results    | latin1
| character_set_server     | latin1
| character_set_system     | utf8
| character_sets_dir       | D:\PROGRA
+--------------------------+----------
9 rows in set (0.03 sec)

now update to 2.3.2 the chinese version,
the database default character set is utf8;

sql>show variables like '%set%';
+--------------------------+--------------
| auto_increment_offset    | 1
| character_set_client     | utf8
| character_set_connection | utf8
| character_set_database   | utf8
| character_set_filesystem | binary
| character_set_results    | utf8
| character_set_server     | utf8
| character_set_system     | utf8
| character_sets_dir       | G:\BitNami\RE
+--------------------------+--------------
9 rows in set (0.00 sec)
mysql> show variables like '%coll%'
    -> ;
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

when import 0.9.4 database to 2.3.2 database ,all the contents of the database cannot be displayed on the home page.

get some can't read character.

Actions #2

Updated by Toshi MARUYAMA over 12 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid
Actions

Also available in: Atom PDF