I have a pre-existing sql file that I'd like to import into SQLite. (eg, via the .read command of the sqlite command line utility).
this sql file creates a bunch of tables. Used in many places are column definitions like this:
replay enum('none','public','private') default NULL,
SQLite apprarently does not support the enum keyword? (It's not listed in the 'Datatypes in SQLite' man page). or does it?
The error message I get for statments like the above is:
SQL error: near "'none'": syntax error
Hmmm...if ENUM was not supported, I would have expected the error to be 'SQL error: near "enum"...'
I've tried using double-quotes instead of single-quotes... same error.
Anyway, how *does* one define the ENUM semantic in SQLite? Do I have to write a user-defined function? (ugh!)
Tia,
- rich
-- rich coco [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
