Skip to Content
0
Former Member
Jun 08, 2009 at 03:12 PM

invalidFieldtype from mysql-tables: chars instead of decimals

37 Views

Fieldtype form mysql-tables accessed via ODBC

are in Crystal Reports 2008

almost all chars instead of decimals

with Crystal Reports 8 it works, with 2008 german (even with SP1) all fieldtypes are false !

Mysql -> CrystalReports

Decimal(1,0) -> Char[2] in german "Zeichenfolge[2]"

Decimal(6,0) -> Char[7] in german "Zeichenfolge[7]"

VarChar(5) -> char[5]

BigInt -> INT

MySQL 5.0.62 (on Window Server 2003)

ODBC : "mysql-connector-odbc-5.1.5-win32.msi"