MySQL Bugs: #73293: Export and decimal delimiter

Bug #73293	Export and decimal delimiter
Submitted:	15 Jul 2014 9:23	Modified:	9 Oct 2014 8:06
Reporter:	Dess Soul	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.2.1	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	comma, decimal, DELIMITER, dot, export

Description:
If local settings set comma as decimal delimiter (in continental Europe for example), MySQL for Excel is unable to export floating number from Excel to MySQL when using "Export Excel Data" function, because it use comma instead of dot for decimal delimiter in the SQL INSERT query.
It result with a "MySQL Error 1136: Column count doesn't match value count at row 1" error.
The only similar problem I have found on internet : http://forums.mysql.com/read.php?172,588604,588604#msg-588604

With Windows 7 and Office 2013.

Error log in MySQL for Excel :
1: INSERT INTO `sakila`.`feuil1` (`feuil1_id`,`test`,`test_2`,`test_3`) VALUES (1,0,636051704363727,0,567006436564644,0,878173318690857)
Error while inserting rows...
MySQL Error 1136:
Column count doesn't match value count at row 1

How to repeat:
Make a table on Excel with floating numbers (user random function for example) and try to export it in MySQL

Verified this problem exists when exporting data where the decimal separator is a comma. This does not happen when appending data, where the comma gets converted to decimal point automatically.

Export data must be fixed to convert commas to decimal points whenever needed.

Posted by developer:
 
Fixed Export Data operations code to create a MySqlDataTable container for the data to be exported with the final data types before the operation takes place, this automatically makes the decimal numbers conversion from any locale to an invariant one.

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.3 release, and here's the changelog entry:

Exporting data that used a comma as the decimal separator would fail to
export. The commas are now converted to periods, as already done when
appending data.

Thank you for the bug report.

Problem presents in version 1.3.6

This will be fixed as part of bug #84049