Oh, and as I recall, sqlite2 completely ignored the type declaration. It stored what you typed in the schema, but did nothing with it.
I am pretty sure that sqlite3 treats text, char and varchar completely the same. It ignores the number after char(x) or varchar(x). David --- On Thu, 12/16/10, Artur Reilin <sql...@yuedream.de> wrote: > From: Artur Reilin <sql...@yuedream.de> > Subject: [sqlite] does sqlite differ between char, varchar and text? > To: "SQLite User Mailing list" <sqlite-users@sqlite.org> > Date: Thursday, December 16, 2010, 1:50 PM > Does sqlite differ between char, > varchar and text? I currently just always > use text. So I wonder if there is any difference if I would > use varchar or > not. I read that there are differences in mysql, but I know > that sqlite > has it's type affinity and such. And does it also count for > sqlite(2). > > (Yeah, I know SQLite(2) is old and such, but I'm still at > the position, > that I only can use this version for my site.) > > with best wishes > > > Artur Reilin > sqlite.yuedream.de > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
