If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: newbie: database with spanish collation

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