On 2/17/18, Ralf Junker <ralfjun...@gmx.de> wrote:
> 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?
The current behavior of the printf() function in SQLite, goofy though
it may be, exactly mirrors the behavior of the printf() C function in
the standard library in this regard.
So I'm not sure whether or not this is something that ought to be "fixed".
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
