Powerdesigner中表导出sql语句关于字段注释乱码的问题问题说明 declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'(MultiRoomInfo)',
'user', @CurrentUser, 'table', 'MultiRoomInfoDetail'
go
解决⽅法
msinfo修改Format中的编码类型
使⽤DataBase Generation批量导出多表时
DataBase Generation->Format->Text formatting->Encoding,
选择简体中⽂GB2312(Cp20936) 项即可。或选项名不⼀样,反正是GB2312.
使⽤Table Properrties表的属性导出单表时
Table Properrties->Preview->Show Generation Options(Ctrl+W)->Format->Text formatting->Encoding,
选择简体中⽂GB2312(Cp20936) 项即可。或选项名不⼀样,反正是GB2312.
修改效果
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'功能教室使⽤登记(MultiRoomInfo)中的学⽣使⽤记录',
'user', @CurrentUser, 'table', 'MultiRoomInfoDetail'
go