SAP Knowledge Base Article - Preview

2542537 - Collation conflict when creating the repository in Turkish database - SAP PD

Symptom

  • A Microsoft SQL Server database has been created with the collation "TURKISH_CI_AS".

    KBA 2542537_1.png

  • While creating the repository, all the SQL statements run successfully and user is prompted to define the repository password.
  • An error is raised when saving documents in the repository:

[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared
SQLSTATE = 37000

  • The repository has been created successfully and is consistent (no error).
  • Database Traces indicate:

ODBC ERROR = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "Turkish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation., sqlState 37000.

  • Turkish characters are not preserved.
  • This issue did not happen in PD 16.6 SP01 PL01 and started with PD 16.6 SP01 PL02. 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • Microsoft SQL Server

Product

SAP PowerDesigner 16.6

Keywords

native, sequence, log, check, checked, 811082, CR811082, CR#811082 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

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.