Bug #15083 Decimal-Columns are of type text in microsoft access
Submitted: 20 Nov 2005 14:29 Modified: 22 Jun 2007 17:00
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:MyODBC 3.51 with 5.0.x OS:Linux (Linux/Windows)
Assigned to: CPU Architecture:Any

[20 Nov 2005 14:29] [ name withheld ] 
Description:
When linking a mysql-table into a microsoft access database via odbc3.51 columns of type decimal(x,0) are interpreted my msaccess as text.

In mysql3 and 4 they have the correct type "number" len x in access.

I found no workaround and had to switch back to version 4.

How to repeat:
Create Table with column decimal(20,0) and link it to ms-access.
Open the propertypage of linked table and inspect the colunmn in question.
[20 Nov 2005 14:37] Valeriy Kravchuk 
Thank you for a problem report. The problem you described has nothing to do with a server itself - it is a known problem in MyODBC 3.51. See http://bugs.mysql.com/bug.php?id=11035 or http://bugs.mysql.com/bug.php?id=11795 for example. Please, use the newer versions of the driver (3.51.12) or use other data type instead.
[22 Jun 2007 17:00] Bogdan Degtyariov 
The bug has been re-verified against MyODBC 3.51.16 and MySQL Server 5.0.41. The problem is fixed.