Stan Lederer wrote:Let's say my columns are col1, col2, col3, col4, and fulltext, where the col* fields are just strings. If I create a CSV file then can Java easily import it?
Shouldn't you be more worried about whether the
database can import it? As Jesper says, many db's can already import CSV files directly.
Or, should I create a file that looks like this?...
My advice: NO. Stick to recognised formats.
However, my other question would be: why does your table include both columns AND 'fulltext'? It seems redundant to me.
You need to ask yourself a few questions:
1. What if somebody changes one of the columns in the resulting table? The column contents and the 'fulltext' will now be out of sync.
2. What if one of those columns is a date, or a currency amount? Doesn't it make more sense to make those column types reflect what it actually
is? (eg, an SQL DATE). Strings make
bad substitutes for other data types.
My 2 cents.
Winston