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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
