CSV implementations may not handle such field data or use quotation marks to surround the field.
The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data may also contain commas or even embedded line-breaks. The comma as a field separator is the source of the name for this file format. Each record consists of one or more fields, separated by commas. In computing, a comma-separated values (CSV) file stores tabular data (numbers and text) in plain text. Thus, they can be opened in Microsoft Excel, OpenOffice Calc, and many other programs. db files can share rich contents between systems by simply exchanging these files over the network. DBF files were one of the first database files with a header that allows programs that do not natively know the data structure in a specific file to read DBF files regardless. It is a database in a file and is used to store data and implement a self-contained, full-featured, highly-reliable SQL database engine.
db extension is a SQL database file created with the SQLite software.
