hi all, I'm a newbie in postgresql and I'm having troubles with database creation.. please help me!!
I have to store data with spanish characters like ,..
when I created a database with createdb command (without any other options), I noticed that the default collation is en_US.UTF-8. I searched in google for a list of valid collations for UTF8, but haven't found anything for spanish
I tried es_ES.UTF-8 collation, tried LATIN1 encoding with ISO-8859-1.. and always it throws error because of invalid collation

how do I create a database with spanish character support?