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.