Hey all; I've seen it grumbled about before about giving a field a property of CHAR, and have seen the correction that it should be TEXT. I understand that SQLite doesn't really "care" what the contents of the field is, but, just out of curiosity, is there a kind of performance hit on using CHAR versus TEXT or INT versus INTEGER?
Other than translating from one database engine to another, and with the fact that SQLite doesn't care what the affinity is (Other than for internal workings), I can't seem to think that there'd be a big hit since it needs to determine what that value is supposed to be when reporting back to the application. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
