So I guess that's a "No" then? I'm fully aware of how sqlite3 treats datatypes and column width specifications, but surely if someone defines a column with a specific max width, it's reasonable to assume that's the max width they want, otherwise why bother defining it? That would seem to be a lot less arbitrary than the current logic for determining the default column width.
On Wed, Apr 25, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 23 > Date: Tue, 24 Apr 2012 13:43:25 -0700 > From: Roger Binns <rog...@rogerbinns.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] sqlite3 column widths > Message-ID: <4f97106d.7080...@rogerbinns.com> > Content-Type: text/plain; charset=ISO-8859-1 > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 24/04/12 13:26, Pete wrote: > > Is there way to have sqlite3 display the columns in the result of a > > SELECT statement using their defined widths in the schema? For example > > if a column is defined as "Name(40) TEXT", I want the column to be 40 > > chars wide. > > Those numbers you put in the schema are ignored by SQLite and do not limit > or provide any hints to any SQLite code. How SQLite deals with types is > detailed here: > > http://www.sqlite.org/datatype3.html > > Separately from that the SQLite source code is public domain and you have > the full rights to modify it, redistribute it etc. You can modify the > code to work however you want. > > Roger > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk+XEG0ACgkQmOOfHg372QRCpgCdEVfimkFYA8kx3WQixtfEVEAs > DpEAoLY1FVYSbQVNZoRM0dTa1fmUbsKj > =uuvW > -----END PGP SIGNATURE----- > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users