I powerdesigner is used to derive the SQL script, and then use Navicat executing scripts, displays the success, the table is set up there is no problem, just field without annotation, strives for the great god asked, here is one of my table SQL statement:
The create table system_role
(
Role_id varchar (8) the not null comment 'part number',
Parent_role varchar (8) the comment 'role parent id,
Role_name varchar (100) not null comment 'character name,
Role_info varchar (100) the comment 'role information,
Gmt_create datetime not null comment 'creation time,
Gmt_modified timestamp not null comment 'modification time,
Primary key (role_id)
);

The alter table system_role comment 'role information;
In addition to add a foreign key statements

CodePudding user response:

There is no answer or did you come, I just find out why, this is caused by coding format, I don't when using powerdesigner export SQL select encoding format, but using the default encoding (not utf-8)

CodePudding user response:

reference 1st floor qq_36357995 response:

there is no answer or did you come, I just find out why, this is caused by coding format, I don't when using powerdesigner export SQL select encoding format, but using the default encoding (not utf-8)

I just want to say is derived when set the coding problem, you will find the answer, because I also like you