Re: [sqlite] how to write "\n\r" each line in the output txt file?

2012-05-16 Thread Donald Griggs
On Wed, May 16, 2012 at 9:30 PM, YAN HONG YE wrote: > > > >when I use : > > > >.output akk.txt > >select * from dhq where qph>0; > >.output stdout > > > > command to write a txt file,I found no "\n\r" in the each line, > > when I use ultraedit to open the txt file, I found

[sqlite] how to write "\n\r" each line in the output txt file?

2012-05-16 Thread YAN HONG YE
>when I use : > >.output akk.txt >select * from dhq where qph>0; >.output stdout > > command to write a txt file,I found no "\n\r" in the each line, when I use ultraedit to open the txt file, I found end of each line is 0x0D, How to write "0x0D 0x0A" each line? may be should change the