SAP Knowledge Base Article - Preview

2625499 - Microsoft SQL Server: Collation name not removed when column data type is changed - SAP PD


  • PowerDesigner (PD) does not remove the collation name associated to a char or varchar column when the data type is changed to int.
  • The COLLATE clause can be applied only for the char, varchar, text, nchar, nvarchar, and ntext data types. 
  • An error is returned when the generated SQL is executed: 

[Microsoft][ODBC SQL Server Driver][SQL Server]Expression type int is invalid for COLLATE clause



 SAP PowerDesigner (PD) 16.6


SAP PowerDesigner 16.6


CR814291, CR#814291, 814291, MSSQL, datatype , KBA , BC-SYB-PD , PowerDesigner , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.