On 10/3/19 5:46 AM, 算 子 wrote: > In column mode, each record is shown on a separate line with the data aligned > in columns. For example: > > sqlite> .mode column > sqlite> select * from tbl1; > one two > ---------- ---------- > hello 10 > goodbye 20 > sqlite> > > > But I found,only when columns text is ANSI,it can normal work. > > sqlite> .mode column > sqlite> select * from 语言声明表; > 语言指针 引用数量 语言名称 语言注释 > ---------- ---------- ---------- ---------- > 1 0 1 0 > 2 0 2 0 > > If the columns text is utf-8,it can't work. > What should I do for it? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
My guess is that column mode doesn't understand all the strangeness that comes with Unicode and fonts, and probably expects that each code point is exactly the same width. I note that at least on my computer the CJK characters are wider than the ASCII characters, and thus makes columns not align. -- Richard Damon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users