On Fri, Jul 18, 2014 at 10:23 AM, Rui Fernandes <[email protected]> wrote:
> Greetings from Portugal, > > I made my firt import of a cvs file to the SQLite, and save it as a file. > My newbie question is that Sqlite is assuming every line as a record of > text, not separating the fields.... > Must the text fiels be surrounded by "? And it will assume the . as decimal > point? > Yes, SQLite always assumes "." is your decimal point. If you have data using "," as the decimal point, you'll have to convert it first. Instructions for doing CVS import on SQLite are at http://www.sqlite.org/cli.html#csv > > Another question is the password: is it possible to place a password to > protect the database? > There is a (non-free) extension for that: http://www.hwaci.com/sw/sqlite/see.html -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
