Testuser=# SELECT * FROM hello ORDER BY m COLLATE "sv_SE" ĮRROR: collation "sv_SE" for encoding "UTF8" does not exist Union all select 'hello world'::text as m RUN localedef -i sv_SE -c -f UTF-8 -A /usr/share/locale/locale.alias sv_SE.UTF-8ĭocker-compose up docker exec -it cac3f23432fb psql -username=testuserĬ.UTF-8 | 11 | 10 | 6 | C.UTF-8 | C.UTF-8Įn_US | 11 | 10 | 6 | en_US.utf8 | en_US.utf8Įn_US.utf8 | 11 | 10 | 6 | en_US.utf8 | en_US.utf8 data/postgresql:/var/lib/postgresql/data Postgres = # SELECT * FROM hello ORDER BY m COLLATE "sv_SE" Ĭollname | collnamespace | collowner | collencoding | collcollate | collctype Postgres - # union all select 'hello world'::text as m Postgres - # select 'hej världen'::text as m > sh -c 'PGPASSWORD=mysecretpw exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres ' $ docker run -rm -it -link pg_sv:postgres \ > postgres96_sv \ Other character sets may be usefulįor backwards compatibility with older systems and software.Īnd choice 1 and after loading all locales I saw UTF-8 locales should be chosen byĭefault, particularly for new installations. Use their language, country, characters, collation order, etc. Locales are a framework to switch between multiple languages and allow users to at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)ĭebconf: falling back to frontend: Readline Perl: warning: Falling back to the standard locale ("C").ĭebconf: unable to initialize frontend: Dialogĭebconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. Perl: warning: Please check that your locale settings:Īre supported and installed on your system. Generating locales (this might take a while). Locale-gen sv_SE.utf8 & dpkg-reconfigure locales
0 kommentar(er)
