From this link http://wiki.postgresql.org/wiki/Todo:Collate and http://www.postgresql.org/docs/9.1/static/collation.html. it's make me confused.
They said, utf-8 support depends on OS capability, and its deferent between every LC_COLLATE and LC_CTYPE options.
When I create database using pdAdmin III, there is 3 option, C, Posix and English_United States.1252. What's the different between C, Posix and English_United States.1252?
I want work with all languages supported, that is unicode utf-8, which doesn't seem to be an option.
What I must chose for the values of LC_COLLATE and LC_CTYPE for creating database that support utf-8 in PostgreSQL 9?