X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=f80fb9a660c75c4ba7980508bbf12b0ed851f3b0;hb=53c92344af793a671019038c8ff21302c7bc2a73;hp=2cf5b75c449fd973e78f9ac3c29bf57eb330117e;hpb=d350340d41cc5e53d0b212c3fd2c3f80cae60a51;p=portal.git

diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index 2cf5b75c..f80fb9a6 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -13,6 +13,12 @@ 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;
+
 use portal;
 
 -- ------------------ create table section
@@ -309,7 +315,7 @@ create table fn_user (
     silo_status character varying(10)
 );
 
-alter table fn_user add column language_id int(2) not null default 1;
+alter table fn_user add column language_id int(2) default 1;
 
 create table fn_language(
     language_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,