[sqlite] printf() problem padding multi-byte UTF-8 code points

[Ralf Junker]

Example SQL:

select
  length(printf ('%4s', 'abc')),
  length(printf ('%4s', 'äöü')),
  length(printf ('%-4s', 'abc')),
  length(printf ('%-4s', 'äöü'))
Output is 4, 3, 4, 3. Padding seems to take into account UTF-8 bytes 
instead of UTF-8 code points.

Should padding not work on code points and output 4 in all cases as 
requested?

Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users