diff options
| author |   shentao999 <shentao@chinamobile.com> | 2019-05-23 19:16:23 +0800 |
|---|---|---|
| committer | shentao999 <shentao@chinamobile.com> | 2019-05-23 19:16:24 +0800 |
| commit | a36849015630aa812736491e630aec7a5b44ecd3 (patch) | |
| tree | 690fc067106d6490563dfb2b9cc176cd489e436d | |
| parent | 306d89bd2673a76939e57186d15ffcd2a504d498 (diff) | |
Change default character to utf8 for portal db
Change-Id: I6a1bb2f1b6b501662c7ae2ca902c3d61c7534125
Issue-ID: PORTAL-565
Signed-off-by: shentao999 <shentao@chinamobile.com>
| -rw-r--r-- | deliveries/my.cnf | 1 | ||||
| -rw-r--r-- | ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 4 |
2 files changed, 3 insertions, 2 deletions
diff --git a/deliveries/my.cnf b/deliveries/my.cnf index 97340675..e06a211c 100644 --- a/deliveries/my.cnf +++ b/deliveries/my.cnf @@ -180,6 +180,7 @@ quote-names max_allowed_packet = 16M [mysql] +default_character_set = utf8 #no-auto-rehash # faster start of mysql but no tab completion [isamchk] diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql index 7469c60b..024f067e 100644 --- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql +++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql @@ -11,14 +11,14 @@ -- ----------------------------------------------------------------------------------------------------------------- set foreign_key_checks=1; -create database portal; - SET GLOBAL character_set_client = utf8; SET GLOBAL character_set_connection = utf8; SET GLOBAL character_set_database = utf8; SET GLOBAL character_set_results = utf8; SET GLOBAL character_set_server = utf8; +create database portal; + use portal; -- ------------------ create table section |