Proposed fix: https://www.sqlite.org/src/ci?name=b1a9e2916f5b4adef91c34563f71b98e79a10c12
On 2/26/15, Adam Podstawczy?ski <adam at podstawczynski.com> wrote: > Hi Ryan, > > I got it from here: > http://jonahellison.com/21640-translated-country-names-unicode-csv > > Also, to provide more input, I have now noticed that even if the column > width is wider than the offending string, this issue still creates problems > ? while nothing gets truncated, the position of the next column is > miscalculated, causing misalignment: > > United States ar ???????? ??????? ????????? > Hackensack > United States ca Estats Units > Hackensack > > United States ca Estats Units > Hackensack > > United States cs Spojen? st?ty > Hackensack > > United States cs Spojen? st?ty > Hackensack > > United States da USA > Hackensack > > United States de Vereinigte Staaten > Hackensack > > United States el ???????? ????????? ??? ???????? > Hackensack > United States el ???????? ????????? ??? ???????? > Hackensack > United States en United States > Hackensack > > United States es Estados Unidos > Hackensack > > United States fi Yhdysvallat > Hackensack > > United States fr ?tats-Unis > Hackensack > > United States he ????? ????? > ??????? > United States hr Sjedinjene Dr?ave > Hackensack > > United States hr Sjedinjene Dr?ave > Hackensack > > Thanks, > -- > adam > >> On 26 Feb 2015, at 13:04, R.Smith <rsmith at rsweb.co.za> wrote: >> >> While it is a presentation issue in the end, it still is an issue, so >> thank you for happening upon it and bringing it to our attention, and no >> need to apologize for lack of investigation. >> >> I think it is possibly the command line utility falling into the >> character-length trap which Hick mentioned when enforcing column widths. >> >> >> Also, it is of course no longer needed to share the import file, but I >> wouldn't mind having a list of country names in localized format - if you >> are happy to share. >> >> >> On 2015-02-26 12:58 PM, Adam Podstawczy?ski wrote: >>> Thank you Ryan. I will provide the files if still necessary, but I have >>> just discovered it has to do with column width. >>> >>> Please compare: >>> >>> .width 5 5 20 >>> select * from countrynameslocalized where iso="AE"; >>> AE gsw Ver?inigti Arabisch >>> AE gu ??????? >>> AE he ????? ????? >>> AE hi ??????? >>> AE hr Ujedinjeni Arapski E >>> AE hu Egyes?lt Arab Emir? >>> AE hy ??????? ??? >>> AE ia Emiratos Arabe Unite >>> AE id Uni Emirat Arab >>> AE is Sameinu?u arab?sku >>> AE it Emirati Arabi Uniti >>> AE ja ??????? >>> AE ka ??????? >>> AE km ??????? >>> AE kn ??????? >>> AE ko ?????? ? >>> AE lo ??????? >>> AE lt Jungtiniai Arab? Em >>> >>> .width 5 5 150 >>> select * from countrynameslocalized where iso="AE?; >>> AE gsw Ver?inigti Arabischi Emir??t >>> AE gu ???????? ??? ???????? >>> AE he ????? ????????? ??????? >>> AE hi ??????? ??? ?????? >>> AE hr Ujedinjeni Arapski Emirati >>> AE hu Egyes?lt Arab Emir?tus >>> AE hy ??????? ???????? ????????? >>> AE ia Emiratos Arabe Unite >>> AE id Uni Emirat Arab >>> AE is Sameinu?u arab?sku furstad?min >>> AE it Emirati Arabi Uniti >>> AE ja ???????? >>> AE ka ???????? ????????????? ????????? >>> AE km ?????????????????? >>> AE kn ??????? ???? ???????? >>> AE ko ?????? ?? >>> AE lo ???????????????????? >>> AE lt Jungtiniai Arab? Emyratai >>> >>> So, it looks like this is a presentation issue in the end. I must have >>> not investigated it properly. >>> >>> While this solves the issue for me, I still believe this behavior is >>> confusing ? truncated characters should be handled more gracefully. >>> >>> Again, thank you for helping out and regards, >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
