Yes, one big, long line. As for displaying, depending on the program you use, \r may get displayed as ^M. For example:
$ echo -ne '\r\n' | cat -A ^M$ $ echo -ne '\r\n' | od -An -abcx cr nl 015 012 \r \n 0a0d Regards, - Robert > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan > Sent: Tuesday, September 08, 2009 2:14 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Importing data into SQLite > > FYI: Mac excel does not separate rows with \r, but inserts a ^M instead. > (I dont have a windows machine with me, I wonder if this is Mac specific) > Sqlite does not like this because a large file with many rows appears as > 1 huge infinite line to sqlite. > Kavita _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
