#1068 Export to CVS bug with numbers represented by an exponent

[Anonymous]

Originally created by: kimwork...@gmail.com

What exact steps will reproduce the problem?
1. Show the data for a table with contains numbers which are written with
an exponent, for example 9,155E-5
2. Right click and export the grid data to an CSV file.
3. Open the exported file

What was the expected output?
The numbers represented by an exponent, will be written as an exponent

What happened instead?
The numbers represented by an exponent, are written as the exponent without
the E syntax, for example 9,155E-5 will be written as 9,1555

Suggested fix (optional)?
Write the same as seen in the data grid

Version used?
HeidiSQL revision: 4.0 RC3, [r2208]
MySQL Server version: 5.1.14
Operating system: Windows Vista

[Anonymous]

Originally posted by: a...@anse.de

Could you provide a sample row and the datatype of the relevant column please?

> 1. Show the data for a table with contains numbers which are written with
> an exponent, for example 9,155E-5

I have the feeling you're storing exponent numbers in a text column, or? If yes,
after exporting, your Excel or whatever breaks it. Converting that column to a
numeric type would fix your problem then.

Status: NeedInfo