-----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