The sqlite3 commandline shell has always defaulted to '|' for the
separator. You may have been using .mode csv which changes the
separator before returning to .mode list:
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> .mode list
sqlite> select 1,2,3;
1|2|3
sqlite> .mode csv
sqlite> select 1,2,3;
1,2,3
sqlite> .mode list
sqlite> select 1,2,3;
1,2,3
--- Rich Shepard <[EMAIL PROTECTED]> wrote:
> Yesterday as I worked on a project database's tables in the SQLite editor,
> I saw that the separator was a comma, ",", and thought the default separator
> must have changed between versions 3.3.x and 3.4.0. But, when I select data
> from the same tables, the separator is back to being the vertical bar, "|".
>
> While I suppose it does not matter what the separator is, I'd like to
> understand why it changed. I made no changes in it, but the .show command
> confirms that it did, indeed, return to the vertical bar from the comma.
____________________________________________________________________________________
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
