Just to be sure try the _select: print db(db.teachers.t_name!='None')._select(db.teachers.t_name, orderby=db.teachers.t_name, distinct=True)
You will should see same result using the resulting statement under psql. Now the problem seems your database. The collation is wrong, since it's for US: LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' Install proper locales for slovenian restart postgres and create a new database with proper collations. See on postgresql.org how to do it. mic 2014-11-04 9:56 GMT+01:00 Niphlod <[email protected]>: > this is more suited to a postgresql forum than a web2py's one.... > > > On Tuesday, November 4, 2014 8:52:54 AM UTC+1, Yebach wrote: >> >> Hello >> >> I have a postgres db with encoding and collation settings >> >> CREATE DATABASE algit_osnovna_sola >> WITH OWNER = postgres >> ENCODING = 'UTF8' >> TABLESPACE = pg_default >> LC_COLLATE = 'en_US.UTF-8' >> LC_CTYPE = 'en_US.UTF-8' >> CONNECTION LIMIT = -1; >> >> When I use select with order by I do not get the right sort order for >> Slovenian language. It is not completely off, but for some letters they are >> treated as the same >> My select >> >> teacher_list=db(db.teachers.t_name!='None').select(db.teachers.t_name, >> orderby=db.teachers.t_name, distinct=True).as_list() >> >> my result >> >> [{'t_name': 'BABI\xc4\x8c Biljana'}, {'t_name': 'BARBO Sre\xc4\x8dko'}, >> {'t_name': 'BARUCA Ingrid'}, {'t_name': 'CERKVENIK Karmen'}, {'t_name': >> 'DANI\xc4\x8cI\xc4\x8c Vu\xc4\x8dko'}, {'t_name': '\xc4\x90OROVI\xc4\x86 >> Aleksandar'}, {'t_name': 'FALKNER Anja'}, {'t_name': >> 'FLORJAN\xc4\x8cI\xc4\x8c Andrej'}, {'t_name': 'GAZI\xc4\x8c Mojca'}, >> {'t_name': 'GORJAN Melina'}, {'t_name': 'GRLJ Vilko'}, {'t_name': 'HARCET >> Franjo'}, {'t_name': 'HRE\xc5\xa0\xc4\x8cAK Erika'}, {'t_name': 'JAHN >> Marjan'}, {'t_name': 'JELEN Branko'}, {'t_name': 'JEREBICA Nevenka'}, >> {'t_name': 'JERMAN Nata\xc5\xa1a'}, {'t_name': 'KING Mojca'}, {'t_name': >> 'KOCJAN\xc4\x8cI\xc4\x8c Dolores'}, {'t_name': 'KOCJAN\xc4\x8cI\xc4\x8c >> Nevio'}, {'t_name': 'KORO\xc5\xa0EC Erika'}, {'t_name': 'KOZJAK Igor'}, >> {'t_name': 'KRAJNC Elvira'}, {'t_name': 'KRT Sini\xc5\xa1a'}, {'t_name': >> 'KUZMAN Franjo'}, {'t_name': 'LEDINEK Bianka'}, {'t_name': 'LENASSI >> Andreja'}, {'t_name': 'MARA\xc5\xbd Jelica'}, {'t_name': 'MAVRI\xc4\x8c >> Barbara'}, {'t_name': 'MEJAK Giliola'}, {'t_name': 'MESARI\xc4\x8c Alen'}, >> {'t_name': 'MIKOLAV\xc4\x8cI\xc4\x8c Mitja'}, {'t_name': 'MUNIH Marko'}, >> {'t_name': 'NOVOSELEC Katarina'}, {'t_name': 'PAULI\xc4\x8c Simona'}, >> {'t_name': 'PE\xc4\x8cAR BOLE Bojana'}, {'t_name': 'PLAZNIK Jadran'}, >> {'t_name': 'PODGORNIK Marko'}, {'t_name': 'POHLEN Doris'}, {'t_name': >> 'POKLAR Branko'}, {'t_name': 'PREGELJC Damjana'}, {'t_name': 'RUDL Ensi'}, >> {'t_name': '\xc5\xa0AV Angel'}, {'t_name': '\xc5\xa0IRCELJ Du\xc5\xa1an'}, >> {'t_name': '\xc5\xa0KERJANC Marko'}, {'t_name': 'SLAVEC Marija'}, >> {'t_name': '\xc5\xa0TEMBERGER Samo'}, {'t_name': 'TRAJBAR Mitja'}, >> {'t_name': 'UMER Jo\xc5\xbea'}, {'t_name': 'URANJEK Damjan'}, {'t_name': >> 'VALENTI\xc4\x8c Maja'}, {'t_name': 'VERGAN Helena'}, {'t_name': 'VOUK >> Renato'}, {'t_name': 'ZAVRTANIK Boris'}, {'t_name': '\xc5\xbdNIDARI\xc4\x8c >> Maja'}, {'t_name': 'ZRINSKI Elen'}] >> >> The problem is for example with {'t_name': '\xc5\xa0AV Angel'}, >> {'t_name': '\xc5\xa0IRCELJ Du\xc5\xa1an'}, {'t_name': '\xc5\xa0KERJANC >> Marko'}, {'t_name': 'SLAVEC Marija'}, {'t_name': '\xc5\xa0TEMBERGER Samo'} >> >> Where 'SLAVEC Marija should be the first one followd by '\xc5\xa0 names >> >> any suggestions? >> >> In my db.py I set encoding to utf-8 but that does not help. >> >> thank you >> >> >> >> >> >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
