-----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-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to