如何为powerdesigner添加charset=utf-8支持

发布网友发布时间：2022-04-24 08:31

共1个回答

热心网友时间：2022-05-03 07:37

create tables for mysql5 by PowerDesigner15

First, create concept-data-model.

And then generate Physical Data Model from Concept-Data-Model.

But there is something that we should pay attention to. I record them as follows.

1. avoiding use mysql keywords like "desc" as column name.

you can use `desc` to avoid keyword conflict if you insist.

But I recommend you to use another word liking explain, addition.

2. set charset utf-8 and set auto_increment

my target:

1 /*==============================================================*/
2 /* Table: student */
3 /*==============================================================*/
4 create table student
5 (
6 id int not null auto_increment,
7 rank_name varchar(80) not null,
8
9 primary key (id)
10 )
11 auto_increment = 1
12 charset = UTF8;

1) create db using charset utf-general_ci

2) set charset for tables.

最新版的PD15中可能没有charset =（GBK）这一项，如果没有的话请按照下面的步骤进行手动添加
1、在PD安装目录下（我的PD安装路径是：C:\Program Files\Sybase\PowerDesigner
15），找到Resource Files文件夹，在Resource
Files中有个DBMS文件夹，找到里面的mysql50.xdb文件，用记事本打开。
2、按Ctrl+F键输入"checksum = %d : list = 0 | 1, default = 0",在其前方加入"charset = %s : list = UTF8 | GBK | GB2312, default = UTF8"如下图：

4. create physical-data-model; select Databases > Default Physical Options

3. set auto_increment = 1, which means increment from 1.

refering to step2.

4. set auto_increment for id.

use the physical data model and do as following instruction.

powerdesigner中怎么给一主键设为自增型auto_increment-针对于Mysql数据库
在你所要设为自增型的键上（比如你的id）双击，弹出一个Column Properties对话框，右下角有一个Identify的选择框，选中它OK，就可以了。
再去查看Preview，就能看到用大写标识出来的AUTO_INCREMENT。