<< Click to Display Table of Contents >>

CSV file specification

CSV (Comma separated value) file is widely used for data exchange between databases. OZ file store supports not only the comma but also the user defined delimiter.

CSV file specifications for file store are:

Supports standard XML file specification without DTD.

First row contains field names, second row contains field types and data record begins from 3rd row.

Fields are separated by the field delimiter and rows are separated by new line.

The second row that contains field types can be omitted.

Following is an example of CSV file using comma(",") as the field delimiter.

no,jumin_id,name,address

INT,VARCHAR,VARCHAR,VARCHAR

1,7411231932347,kim,seoul

2,6305212983717,lee,pusan

3,7006031837261,park,daegu

4,7271722848281,song,daejeon