On Fri, Apr 23, 2010 at 08:52:37AM -0500, Jay A. Kreibich wrote: > On Thu, Apr 22, 2010 at 06:31:07PM -0400, Derek Martin scratched on the wall: > > Hi, > > > > I have a query that produces about 10 columns, some of which are very > > wide. When I run sqlite3 with -column -header, it truncates all > > fields to 10 characters. This makes the query absolutely useless. > > How can I turn off this truncation? > > > > I already tried explicitly setting the width to 0, that did not help. > > Pick large enough values, or don't use column mode.
Sadly that was the conclusion I had reached before asking here. Needless to say, that was not the answer I was hoping for. Column mode (without any truncation) is the format desired for these reports... Picking large enough values is bad, because it means that I'd need to specify very large column widths for most of the columns, which in many cases would needlessly make the report tediously wide, to accomodate some less common cases where the reports generate very wide columns. Avoiding this is sort of the point of databases doing this for you... ;-) It would be swell if sqlite3 had a -notruncate option or some such, though adding one now wouldn't really solve my immediate problem, since that wouldn't be available on our desktop image. With its current behavior, column mode seems fairly worthless to me. I guess I'll need to convince folks that HTML output is suitable, or that they need to install some other database thingy to run this stuff. Using sqlite3 for this seemed perfect, since it's already available to everyone. Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
