Re: [sqlite] how to write line feed \n\r when output a txt file

2012-05-15 Thread Jean-Denis MUYS
On 14 mai 2012, at 21:03, Kees Nuyt wrote: On Mon, 14 May 2012 05:41:08 +, YAN HONG YE yanhong...@mpsa.com wrote: […] By the way, common lineendings are platform dependent MS Windows: \r\n = 0x0D 0x0A = cr lf Unix/Linux: \n= 0x0A = lf Apple Mac: \r= 0x0D = cr This is

Re: [sqlite] how to write line feed \n\r when output a txt file

2012-05-14 Thread Kees Nuyt
On Mon, 14 May 2012 05:41:08 +, YAN HONG YE yanhong...@mpsa.com wrote: when I use : .output akk.txt select * from dhq where qph0; .output stdout command to write a txt file,I found no \n\r in the each line, Are you sure? By the way, common lineendings are platform dependent MS Windows:

Re: [sqlite] how to write line feed \n\r when output a txt file

2012-05-14 Thread Black, Michael (IS)
@sqlite.org Subject: EXT :Re: [sqlite] how to write line feed \n\r when output a txt file On Mon, 14 May 2012 05:41:08 +, YAN HONG YE yanhong...@mpsa.com wrote: when I use : .output akk.txt select * from dhq where qph0; .output stdout command to write a txt file,I found no \n\r in the each line

[sqlite] how to write line feed \n\r when output a txt file

2012-05-13 Thread YAN HONG YE
when I use : .output akk.txt select * from dhq where qph0; .output stdout command to write a txt file,I found no \n\r in the each line , how to write \n\r each line in the output txt file? ___ sqlite-users mailing list sqlite-users@sqlite.org