1206218 - Table names are truncated in a MySQL database

SAP Knowledge Base Article - Public

1206218 - Table names are truncated in a MySQL database

Symptom

In a MySQL database, if the table and column/field names are longer than 21 characters, the table name gets truncated.

Cause

You are using the MySQL ODBC driver version 3.51.20 or later.

Resolution

Download and install MySQL 3.51.11 or 3.51.12 ODBC driver from here.

Keywords

MySQL, table name, truncation , 9071434 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2