Re: [sqlite] does sqlite differ between char, varchar and text?

On 16 Dec 2010, at 7:26pm, David Bicking wrote: > Oh, and as I recall, sqlite2 completely ignored the type declaration. It > stored what you typed in the schema, but did nothing with it. True. Only the value stored mattered, and then only for the purposes of comparison and sorting: http://ww

Re: [sqlite] does sqlite differ between char, varchar and text?

, Artur Reilin wrote: > From: Artur Reilin > Subject: [sqlite] does sqlite differ between char, varchar and text? > To: "SQLite User Mailing list" > Date: Thursday, December 16, 2010, 1:50 PM > Does sqlite differ between char, > varchar and text? I currently just al

Re: [sqlite] does sqlite differ between char, varchar and text?

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 wrote: > From: Artur Reilin > Subject: [sqlite] does sqlite differ between char,

[sqlite] does sqlite differ between char, varchar and text?

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