phpmyadmin exporting to csv issue
Posted: Tue Aug 12, 2014 2:27 pm
hello,
i have a database their all tinytext fields and the data in my database is all correct
however when i export to CSV it is stripping all the 0's if 0 is the beginning of a number for example 012345 is coming out as 12345 and i have a field that is like this JAN 09 in my db and the CSV makes it Jan-09 .. puts it into lowercase and replaces a space with a -
any body know why this is happening?
thank you
i have a database their all tinytext fields and the data in my database is all correct
however when i export to CSV it is stripping all the 0's if 0 is the beginning of a number for example 012345 is coming out as 12345 and i have a field that is like this JAN 09 in my db and the CSV makes it Jan-09 .. puts it into lowercase and replaces a space with a -
any body know why this is happening?
thank you