WARNING: This server is unstable and will be retired in the next days.
If you want to keep this forum available, please request immediately a migration
on the Nabble Support forum.
Forums that don't receive any migration request will be deleted forever.
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.
> Message: 23
> Date: Tue, 24 Apr 2012 13:43:25 -0700
> From: Roger Binns <rogerb@...>
> To: General Discussion of SQLite Database <sqlite-users@...>
> Subject: Re: [sqlite] sqlite3 column widths
> Message-ID: <4F97106D.7080301@...>
> 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.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
> -----END PGP SIGNATURE-----