I am exporting data from an SQL database and importing it into R. This is a two step process since I first (automatically) download the data to a hard drive and then import the file with R.
Currently, I am using csv files to save the data. Everybody supports csv. But csv does not support type information. This makes it sometimes cumbersome to load a csv file because I must check all the column types. This seems unnecessary because the SQL database already specifies the types of the columns.
I want to know if there is a broadly accepted file format to save data that also specifies the type of the columns.
Currently I am working with SQL databases, FME ETL'ing and R but I think this is an issue for every data tranfer.