SAP Knowledge Base Article - Preview

2015659 - Cannot specify an index prefix length for index columns – MySQL – SAP PD 16.5.3


  • Cannot define length value for index columns in PowerDesigner using the following syntax:

CREATE INDEX Index_1 ON Table_1 (Col_1(255)).

  • Without this length value defined, an error may be returned when executing the SQL script:

"Specified key was too long; max key length is 767 bytes".

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



  • SAP PowerDesigner (PD) 16.5 SP03
  • SAP PowerDesigner (PD) 16.5 SP03 PL02
  • MySQL 5.0
  • MySQL 5.5


SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5


CR763753, 763753 , 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.