Bug #22218 Field type DECIMAL in Mysql 5.0 Crystal Reports 9 display as STRING

• Submitted: 10 Sep 2006 2:29
• Modified: 22 Oct 2006 15:59
• Reporter: FERNANDO ESPIN PAREDES
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 3.51.12
• OS: Any
• CPU Architecture: Any

[10 Sep 2006 2:29] FERNANDO ESPIN PAREDES

Description:
I have a MySQL table with a field type DECIMAL(9,0) when use MySQL 4.1 with 3.51 ODBC conexion, in Crystal Reports 9 this fields look like NUMBER but with MySQL 5.0 with 3.51 ODBC conexion this field look like STRING and reports do not run.

How to repeat:
Create a table with a field type DECIMAL(9,0)in MySQL 5.0 and then look this table with Crystal Reports 9 it's look like STRING.
Then create the same table in Mysql 4.1 and then look this table with Crystal Reports 9, and this look as NUMBER.

[22 Oct 2006 15:59] Tonci Grgin

Hi Fernando and thanks for your problem report. Please review http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html.
I have no problems using DECIMAL field in CR but I have version XI, so you may consider to upgrade...

mysql> show create table tstdec\G
*************************** 1. row ***************************
       Table: tstdec
Create Table: CREATE TABLE `tstdec` (
  `fld1` decimal(9,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> select * from tstdec;
+------+
| fld1 |
+------+
|    0 |
|    1 |
+------+
2 rows in set (0.00 sec)

tstdec.fld1 is correctly recognized as being of type "number" by CR XI.