Skip to content

Instantly share code, notes, and snippets.

@derencius
Created March 28, 2013 03:56
Show Gist options
  • Save derencius/5260463 to your computer and use it in GitHub Desktop.
Save derencius/5260463 to your computer and use it in GitHub Desktop.
postgres lc_collate
CREATE DATABASE "db" with ENCODING = 'unicode' lc_collate='pt_BR.UTF-8' lc_ctype='pt_BR.UTF-8' TEMPLATE=template0;
show lc_collate;
select * from (values('Éder', 'Eda', 'Edu')) x order by 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment