1. 安装

  • Trial ⇒ Hong Kong;

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);

4. 列头和过滤

  • 双击Table → Columns → Customize Columns and Filter;

  • 必选项:Name,Code,Comment,Default Value,Data Type,Length,
    Precision,Primary,Foreign Key,Mandatory,Unsigned;

  • 可选项:Charset,Collate,ZeroFill;

5. 字段置空

  • Database ⇒ Edit Current DBMS ⇒ Script ⇒ Sql ⇒ Syntax ⇒ Quote;

  • 将右侧Value里单引号去除即可;