Defect #14718
closedupdate redmine 0.9.4 to 2.3.2 ,database encoding problem
0%
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.
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.
Updated by Toshi MARUYAMA over 12 years ago
- Status changed from New to Closed
- Resolution set to Invalid