There's a problem aligning columns containing UTF-8 (non-ASCII) characters correctly when output is done in column mode.
The .width was set as ".width 5 30 15 15 10 30 10" and here's an example of the incorrect output: (Maybe paste into editor with fixed width font to better see the error) =============================================== BookI Title Last Name First Name Date Read Original Title Story Titl ----- ------------------------------ --------------- --------------- ---------- ------------------------------ ---------- 20 Bakom fasaden Sandemo Margit 0 20 Bakom fasaden Sandemo Margit 2010-07-02 13 Blodshämnd Sandemo Margit 0 13 Blodshämnd Sandemo Margit 2010-06-19 10 Bödelns dotter Sandemo Margit 0 10 Bödelns dotter Sandemo Margit 2010-06-11 24 Demonen och jungfrun Sandemo Margit 0 24 Demonen och jungfrun Sandemo Margit 2010-07-08 43 Demonernas fjäll Sandemo Margit 0 43 Demonernas fjäll Sandemo Margit 2010-07-25 =============================================== Columns with special characters like ("å" "ä" "å") get too short widths when output. I guess this is due to the shell not counting actual UTF8 *characters/code points* when calculating the widths, but instead only counting the plain bytes in the strings, so they will seem longer until they are actually printed to the console. The output was done to a Windows console with code page set to 65001. -- Niklas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users