Table Structure Design with PowerDesigner – Express into SQL scripts, and solve Chinese garbled

For newcomers who are new to PowerDesigner, if you use PowerDesigner to design the structure of the table, if you just simply design the mapping relationship of the data model to view it, then there is no problem.

If it is to design the table structure of a certain table, then it will definitely take more time to design using it. Especially when the project is in a hurry, it is easy to waste extra time.

All in turn, we use other tools such as Navicat to design the table structure, import the sql footsteps of the sql table design, and then import it to the physical model of the PowerDesigner to generate the table in reverse. , And then you can export the pdm data table model. This is faster, so I can use PowerDesigner slowly when I have time in the future

http://database.51cto.com/art/201108/284893.htm

http:/ /jingyan.baidu.com/article/a948d6517d8ce50a2ccd2e58.html

Or we have the SQL text for the table design of the entire database, then we want to intuitively and easily see the direct mapping relationship between the tables, also It can be used like this.

But when importing, you will encounter the problem of Chinese garbled characters. So what should be done at this time?

Reference address: https://my.oschina.net/yonge/blog/167?p=1

Occasionally opening the SQL script file, the Chinese in the file is garbled of. Then I modified the encoding of the script generated by PowerDesigner. This time I chose UTF8 encoding, and the Chinese in the SQL file that came out was normal. (Open PDM, select Database——Generate DataBase——Format——Text Formatting, select UTF8)

But it is still garbled when it is opened in MYSQL Query Browser.

Then don’t worry at this time. See if there is a character set setting. ?

Generally, the character set of the database is UTF-8. Look at our sql scripts everywhere and it is also uft-8.

Then you will think of whether it is when importing. Wrong character set?

Sure enough, when importing the script, when PowerDesigner imported the sql script–there is one option I didn’t see

–Database–Selection There is also an Options next to this time Found that he has a character set selected by file encoding, that’s it. Select the corresponding character set, generally utf-8 is fine. Finally, I found that there is no Chinese garbled, which is solved perfectly, and it can also export pdm very well.