Just from some quick command line tool playing around, a dirt quick fix presented itself. .mode csv followed by .mode column (following the .mode ascii operation) seems to return the .column mode to normal. This on SQLite 3.16.2 on Linux command line. I'm not suggesting this as a fix as Dr Hipp has already attended to that but I found it interesting anyway.
On 27 January 2017 at 12:54, Richard Hipp <[email protected]> wrote: > On 1/26/17, Nikolas Manes <[email protected]> wrote: > > Hello, > > I am Nikolas and facing an issue with sqlite, could you please help? > > You will find more details on the link bellow. > > http://stackoverflow.com/q/41730574/6293866 > > The ".mode ascii" command changes the default row and column separators. > > Check-in https://www.sqlite.org/src/info/58f02e6eae8fc9e2 enhances the > command-line shell to change the row and column separator strings back > to the default when you do ".mode column". This enhancement will > appear in the next release. Or you can recompile using the code on > trunk, which is stable. > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Michael.j.Falconer. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
