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
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
, 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
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: