Just wondering why the SQLiteAdapter uses CHAR as the format for 'string' instead of VARCHAR like the other adapters?
From here- http://sqlite.org/datatype3.html: "If the declared type of the column contains any of the strings "CHAR", "CLOB", or "TEXT" then that column has TEXT affinity. Notice that the type VARCHAR contains the string "CHAR" and is thus assigned TEXT affinity." Not a big issue, just would make cross database movements easier. Thanks, -- Adrian Klaver [email protected]
