Bug #12388 Decimal comma in Excel changed to decimal point with vs 5.0.10
Submitted: 4 Aug 2005 16:04 Modified: 11 Aug 2005 18:42
Reporter: Lars Johansson Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql 5.0.10 OS:Linux (Mandriva LE 2005)
Assigned to: CPU Architecture:Any

[4 Aug 2005 16:04] Lars Johansson 
Description:
Import mysql 5.0.10 decimal data to Excel via import external data -> new db query
select decimalcolumn from table

Importing from Mysql rel 4.1.11 gives decimal comma (,) in Excel.
Importing from Mysql rel 5.0.10 gives decimal point (.) in Excel.

It seems only values created in vs 5.0.11 are affected.

ODBC driver 3.51

Windows XP professional 5.1.2600 SP2 build 2600
Microsoft Office Excel 2003 (11.6355.6360) SP1
Locale Sweden  

How to repeat:
Import decimal values with decimals into Excel from mysql 4.1.11 and 5.0.10
and compare the result.
[4 Aug 2005 16:12] Lars Johansson 
Note! It seems only values created in vs 5.0.10 are affected.
[11 Aug 2005 18:42] Aleksey Kishkin 
Hi! 
since version 5.0.3 format of decimal was changed. here: http://dev.mysql.com/doc/mysql/en/precision-math-decimal-changes.html you can read it more detailed. 

PS: upgrading from 4.1 to 5.0 requires some work with decimal: http://dev.mysql.com/doc/mysql/en/upgrading-from-4-1.html