I have a database table containing a payload field which holds a string / ascii text representing the hex value, like “4E88F2”. When requesting the table to be exported to a CVS (auto emailed to my account) however, instead of providing the literal data - some of the (ascii-)hex values get mistakenly converted to e-numbers. And thereby destroying the hex-notation !!
For example: hex string “1814e6” gets exported to the CVS file, as “84E+09”.
Likewise: “eae898” gets converted to “7.452E+12”, which shows in excel as a value “1840000000”.
Certainly this shouldn’t be happening… Anyone else noticed this!?!
Thanks in advance,