If I recall correctly, sqlite2 stores everything as text. It doesn't have a concept of affinity. Everythign is text and it will convert anything as needed.
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