sqlite3 create table col width?

2007-08-04 Thread jim-on-linux
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

Re: sqlite3 create table col width?

2007-08-04 Thread Paddy
On Aug 4, 6:51 pm, jim-on-linux [EMAIL PROTECTED] 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

Re: sqlite3 create table col width?

2007-08-04 Thread 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

Re: sqlite3 create table col width?

2007-08-04 Thread jim-on-linux
On Saturday 04 August 2007 14:05, Carsten Haese wrote: 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

Re: sqlite3 create table col width?

2007-08-04 Thread Ben Finney
jim-on-linux [EMAIL PROTECTED] writes: PY help, Using sqlite3 v3.1.3 You made this message a reply to an existing discussion, so your message is now part of that existing discussion. Please start a new discussion thread by composing a new message. -- \ True greatness is measured