We all know that using PD to design database export by default UTF-8 encoding, then set the character encoding to GBK or GB2312 in PowerDesigner. Here I take the latest powerdesign 15 as an example to show you the following:
Right-click the Designed database table in PD, select Properties (property options), and select the Physical Options tab in the Open Properties dialog box, as shown in the following illustration:
The latest version of the PD15 may not have charset = (GBK), if not, follow the steps below to manually add
1, in the PD installation directory (my PD installation path is: C:/Program Files/sybase/powerdesigner 15), Find resource Files folder, in resource files have a DBMS folder, Find the Mysql50.xdb file inside and use Notepad to open it.
2, press ctrl+f key input "checksum =%d:list = 0 | 1, default = 0 ", add" charset =%s:list = UTF8 in front of it | GBK | GB2312, default = GBK "The following figure:
3. Save the modified file (ctrl+s), then restart the PowerDesigner software, right-click the Designed database table in PD, select Properties (property options), and select the Physical Options tab in the Open Properties dialog box. can appear charset = (GBK), if you need other encoding can choose the appropriate encoding, the following figure: