-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Angus March
Sent: Tuesday, September 22, 2009 8:40 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Why are allowed to keep a text of 3 characters in
a field that has been set to 2?
One thing that I haven't been able to find explicitly is there is no
advantage to using CHAR(2). In my db I have blobs and strings that are
of an exact length, but I don't bother declaring them as anything but
BLOB and TEXT, since I don't expect it'll optimize anything. So can
someone confirm for me that CHAR(2) does nothing for efficiency and
everything for compatibility?
[[glauber]] Correct. It's useful for documentation purposes only.
g
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
