Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-09 Thread Jean-Denis Muys
On 9/8/09 22:24 , various people wrote: Unfortunately, the 3 main families of small computer operating systems have 3 different definitions of what a text file is... DOS/Windows (PC): lines are terminated with CR+LF Unix: lines are terminated with LF Macintosh: lines are terminated with

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-09 Thread Jim Showalter
reasons. - Original Message - From: Jean-Denis Muys jdm...@kleegroup.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wednesday, September 09, 2009 6:09 AM Subject: Re: [sqlite] Importing data into SQLite - text files are not really portable On 9/8/09 22:24

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-09 Thread P Kishor
- From: Jean-Denis Muys jdm...@kleegroup.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wednesday, September 09, 2009 6:09 AM Subject: Re: [sqlite] Importing data into SQLite - text files are not really portable On 9/8/09 22:24 , various people wrote

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-08 Thread Rich Shepard
On Tue, 8 Sep 2009, Ribeiro, Glauber wrote: Unfortunately, the 3 main families of small computer operating systems have 3 different definitions of what a text file is... This causes no end of trouble when moving text files between these kinds of systems. I've never worked with a Mac so I

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-08 Thread Ribeiro, Glauber
Unfortunately, the 3 main families of small computer operating systems have 3 different definitions of what a text file is... DOS/Windows (PC): lines are terminated with CR+LF Unix: lines are terminated with LF Macintosh: lines are terminated with CR This causes no end of trouble when moving

Re: [sqlite] Importing data into SQLite - text files are not really portable

2009-09-08 Thread Robert Citek
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: