Hello, I searched the bug tracker and the only thing I saw that looked relevant was ticket UUID 6c266900a22574d4d6474503da5bfe849c8b244f. http://www.sqlite.org/src/tktview?name=6c266900a2
However, that seems to deal with special Unicode characters and I'm not dealing with that here. I'm using SQLite 3.8.11.1 on Windows 7 Pro 64 built with Visual C++ 2010. I was trying to create a table with a column for IPv4 addresses as VARCHAR. It seems when I set the .mode to column that some records are truncated on the right. Changing the .mode fixes the problem, so I would think it has to do with the column width calculation. Following my sig is some example code. You will see .mode is changed to column then "172.16.18.239" is truncated to "172.16.18.23". In the second example you will see "10.999.987.25" gets truncated to "10.999.987.". Thanks to everyone for your help. If there is any more info you need please let me know. Also, if anybody can tell me what file/function in the source deals with this I would appreciate it. Thank you, Justin Adams Example 1 ======================================================== C:\>C:\app\sqlite\sqlite3.exe C:\Temp\bugdemo.sqlite SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter ".help" for usage hints. sqlite> CREATE TABLE ipAddresses(ip VARCHAR(20) PRIMARY KEY); sqlite> INSERT INTO ipAddresses VALUES ('10.186.34.23'), ('192.168.1.4'), ('172.16.18.239'), ('54.6.74.21'), ('8.8.8.8'); sqlite> SELECT * FROM ipAddresses; 10.186.34.23 192.168.1.4 172.16.18.239 54.6.74.21 8.8.8.8 sqlite> .header on sqlite> .mode column sqlite> SELECT * FROM ipAddresses; ip ------------ 10.186.34.23 192.168.1.4 172.16.18.23 54.6.74.21 8.8.8.8 sqlite> .mode list sqlite> SELECT * FROM ipAddresses; ip 10.186.34.23 192.168.1.4 172.16.18.239 54.6.74.21 8.8.8.8 sqlite> .mode column sqlite> SELECT * FROM ipAddresses; ip ------------ 10.186.34.23 192.168.1.4 172.16.18.23 54.6.74.21 8.8.8.8 ======================================================== Example 2 ======================================================== C:\home\db\static>C:\app\sqlite\sqlite3.exe static.sqlite SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter ".help" for usage hints. sqlite> .schema CREATE TABLE tableCategories(category VARCHAR(16) PRIMARY KEY); CREATE TABLE tableSites(siteName VARCHAR(64) PRIMARY KEY); CREATE TABLE tableStatic ( ip VARCHAR(16) PRIMARY KEY, location VARCHAR(64) REFERENCES tableSites (siteName) ON UPDATE CASCADE, category VARCHAR(16) REFERENCES tableCategories (category) ON UPDATE CASCADE, description VARCHAR(64) ); sqlite> SELECT ip, category FROM tableStatic; 10.537.79.7|PBX 10.999.987.25|PBX sqlite> .mode column sqlite> SELECT ip, category FROM tableStatic; 10.537.79.7 PBX 10.999.987. PBX sqlite> SELECT category, ip FROM tableStatic; PBX 10.537.79.7 PBX 10.999.987. sqlite> .mode list sqlite> SELECT category, ip FROM tableStatic; PBX|10.537.79.7 PBX|10.999.987.25 ======================================================== Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.