2. 字符集
-
File ⇒ New Model ⇒ Category ⇒ Information ⇒ Physical Data
⇒ Input Model Name And Dbms(mysql50.xdb); -
打开${PowerDesignerHome}/Resource Files/DBMS/mysql50.xdb;
-
查询字符串:avg_row_length = %d;
-
查询字符串:checksum = %d : list = 0 | 1, default = 0,如909行;
-
在两行字符串之间插入engine,charset and collate,如下所示:
avg_row_length = %d
ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM, default = InnoDB
charset = %s : list = UTF8 | GBK | GB2312, default = UTF8
collate = %s : list = utf8_bin | utf8_general_ci | gbk_bin | gbk_chinese_ci, default = utf8_general_ci
checksum = %d : list = 0 | 1, default = 0
-
重启Power Designer,Select Engine,Charset and Collate;
-
Database ⇒ Default Physical Options ⇒ Table;
engine = (InnoDB)
charset = (UTF8)
collate = (utf8_general_ci)
-
其它方式设置(末尾追加以下内容):
-
Database ⇒ Edit Current Dbms… ⇒ Mysql5.0
⇒ Script ⇒ Objects⇒ Table ⇒ Options
ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM, default = InnoDB
charset = %s : list = UTF8 | GBK | GB2312, default = UTF8
collate = %s : list = utf8_bin | utf8_general_ci | gbk_bin | gbk_chinese_ci, default = utf8_general_ci
3. 颜色
-
Tools ⇒ Display Preferences ⇒ Format ⇒ Table ⇒ Modify;
-
设置line style,fill,shadow:#FFFFFF(white) ⇒ #B2D6FC(178,214,252);