sqlite3 create table col width?

[Carsten Haese]

On Sat, 2007-08-04 at 13:51 -0400, jim-on-linux wrote:
> PY help,
> 
> Using sqlite3 v3.1.3
> 
> When I create a table collumn using;
> 
> newcollum VARCHAR(35),
> 
> I get a default of 10 spaces.
> 
> No matter what I set the size to I get 10 spqces, 
> even using varchar(0) defaults to 10 spaces.
> 
> I would appreciae the help if someone could tell 
> me what I'm missing, I want to varry the column 
> sizes.

What you're missing is that sqlite columns are type-less. Column type
and size are irrelevant:

>>> import sqlite3
>>> conn = sqlite3.connect(":memory")
>>> cur = conn.cursor()
>>> cur.execute("create table t1 (c1 varchar(35))")
<sqlite3.Cursor object at 0xb7f6dbf0>
>>> cur.executemany("insert into t1(c1) values(?)",
...     [ ("X"*i*10,) for i in range(10) ] )
>>> cur.execute("select * from t1")
<sqlite3.Cursor object at 0xb7f6dbf0>
>>> for row in cur: print row
... 
(u'',)
(u'XXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)
(u'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',)

Even though the column was created to be 35 characters wide, it'll
happily accept 100-character strings.

HTH,

-- 
Carsten Haese
http://informixdb.sourceforge.net