Re: [sqlite] results of SELECT contains carriage returns

Following up my earlier post: I have a database where some values contain carriage returns. I am using the command line to execute sqlite commands, eg: sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe

Re: [sqlite] results of SELECT contains carriage returns

On 10/9/06, T <[EMAIL PROTECTED]> wrote: Hi He, >> sqlite3 Disney.db "SELECT * FROM Characters" >> >> When I get the result of a SELECT statement, the output has >> columns separated by pipe characters and rows by new lines. So, if >> a value contains a return, it prematurely starts a new line,

Re: [sqlite] results of SELECT contains carriage returns

Hi He, sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe characters and rows by new lines. So, if a value contains a return, it prematurely starts a new line, and messes up my output result. Well, you

Re: [sqlite] results of SELECT contains carriage returns

Hi, I have a database where some values contain carriage returns. I am using the command line to execute sqlite commands, eg: sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe characters and rows by new lines.