On 11/8/05, Roger Espinosa <[EMAIL PROTECTED]> wrote:
> So now I'm getting spooked: using "length" generates a fixed width column,
> vs. VARCHAR? For some daft reason, I'd been going under the idea that using
> "length" gave you VARCHAR, and no length gave you the approriate BLOB-ish
> type (TEXT for MySQL, etc). Oracle still has 4K limits on VARCHAR, for
> example...
Adding length does give you VARCHAR, at least for sqlite:
CREATE TABLE song (
id INTEGER PRIMARY KEY,
name VARCHAR(200),
album_id INT
);
Kevin
