>SQLite treats all integers as long long internally. That is the >only way it has to store integers. When writing to the database >file, it tries to store the integers in fewer bytes but that is >mere compression. Fundamentally all integers in SQLite are 64 >bits long.
Ok, this is what I inferred to be the case...good to hear it definitively stated, though--thx. >I do not have any idea how you are are getting the results that >you report. I am unable to reproduce them. As I mentioned to Dennis, I'm going to update to v3.2.2 now and see if the issue persists. I'll post again once I determine the results... thx! sdm ----------------------------------------- Stephen D. Miller Software & Networking Solutions Consultant ThinkGear, Inc. (888) 5-THINKGEAR / www.thinkgear.com

