Bug #26927 Blank fields get corrupted data, when exporting via Access

• Submitted: 7 Mar 2007 17:40
• Modified: 10 Jul 2007 5:48
• Reporter: [ name withheld ]
• Status: Closed
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 5.00.11
• OS: Windows (Windows XP)
• Assigned to: Jess Balint
• CPU Architecture: Any

[7 Mar 2007 17:40] [ name withheld ]

Description:
When exporting an Access table to MySQL via ODBC, any field with a blank value will be a random/corrupt string when inserted into the database.

How to repeat:
n/a

[7 Mar 2007 17:42] Jess Balint

Verified.

Create an Access table with an empty field. Query shows in general log like so:

(5th column is empty)

299 Query       INSERT INTO `test_sa` VALUES ('c','c','','','ï¿¿ï¿¿ï¿¿',NULL)

[8 Mar 2007 0:11] Jess Balint

bug in driver, committed in rev#812

[27 Mar 2007 13:56] Lars Johansson

Hi, 
My problem look very much the same as this bug. Except I'm running from Excel. 

Connecting from Excel 2003 to Mysql 5.1 via ODBC driver 5.0.11.00 gives:
1. The tables listbox is initially blank. You have to refresh it before the    table names show up.

2. Table names with an ebedded space are prefixed with #mysql50# in the table listbox.
  
3. Character columns show up ok in Microsoft Query but gets distorted when exported to Excel.
E.g. 'Nacka' in Query, shows as '?Dtes' in Excel.
Doing a refresh data in Excel makes the first character column show up ok, other character columns is still distorted.

I hope I didn't distort this bug report. [e-mail]