Hi TIm,
sqlite3 already includes the ability to define the width manually with the
.width command. I was hoping that there might be a way to use the defined
string length as part of the default when .width is not used.
Pete
On Thu, Apr 26, 2012 at 9:00 AM, sqlite-users-requ...@sqlite.org wrote:
-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
On 25 Apr 2012 at 17:36, Pete p...@mollysrevenge.com wrote:
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
-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