What is your expected answer for:
select length(printf ('%4s', 'です'))
-Rowan
On 18 February 2018 at 01:39, 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?
>
> Ralf
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
