Hi,
I am currently working with a PostgreSQL database created with WIN1252 encoding because the data will be in Spanish language. So, both Collation and Character type are set to Spanish_Mexico.1252
After reading a bit more about encoding, it seems to me that I can use UTF8 encoding so characters for all languages are available and keep Collation and Character type as Spanish_Mexico.1252. I guess that using UTF8 as the encoding method will keep databases more general. I think that using WIN1252 for encoding is restrictive.
Does it make sense?
Regards,
Jorge Maldonado