PostgreSQLã§templateã¨ç°ãªãencoding,collate,ctypeã§ãã¼ã¿ãã¼ã¹ãä½æããå ´åã ãããªé¢¨ã«createdbã§æå®ãè¡ãã¾ãã $ createdb -E UTF8 -T template0 --lc-collate=ja_JP.UTF-8 --lc-ctype=ja_JP.UTF-8 testdb # su - postgres $ psql postgres=# \l List of databases Name    | Owner | Encoding | Collate |    Ctype    | Access privileges -----------+----------+-----------+-------------+-------------+----------------------- postgres | postg
{{#tags}}- {{label}}
{{/tags}}