I probably wouldn't use INT for that data. I would use TEXT. My feeling is that the data is not so much a number as it is an incoming stream of characters from an IO device. So, I suspect code built around a TEXT column will ultimately be more rational looking. For example, you won't have to pad periodically pad your data with zeros, there won't be any signed-vs.-unsigned confusion, etc.
The one drawback is that an INT implementation may be more optimal than a TEXT implementation. The string "65535" takes up at least 5 bytes, for example, whereas the number 65535 (base 10) will fit in two bytes. ________________________________________ From: [email protected] [[email protected]] On Behalf Of Simon Davies [[email protected]] Sent: Wednesday, September 02, 2009 9:05 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Integer Storage class 2009/9/2 Sebastian Bermudez <[email protected]>: > Ok. my problem is my SQLITE front end (SQLITE ADMINISTRATOR v 0.8.3.2) ... > show me 0 (cero) in that column. Looks like SQLITE ADMINISTRATOR v 0.8.3.2 only deals with signed 32 bit values. 2147483647 it accepts as a valid value, 2147483648 it rejects, saying that it is not a valid integer. > > thanks > Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users The information contained in this e-mail is privileged and confidential information intended only for the use of the individual or entity named. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender and delete any copies from your system. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
