On 2/17/18, Ralf Junker <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
