"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > > Now comes the fun part. I'm converting these databases (and there are > a LOT of them), I'm doing "sqlite OLD.DB .dump | sqlite3 NEW.DB" which > works flawlessly. Is there any way to change the schema on the fly to > say "Varchar(1024)" instead of just "varchar" (or just use an SQLite > 'type' of "text") ? >
Do "sqlite OLD.DB .dump >temp.sql" Bring up temp.sql in a text editor. Find the CREATE TABLE statements. Modify the column types to be whatever you want. Save the file. Then do "sqlite3 NEW.DB <temp.sql". -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
