WIN1252 vs UTF8 database encoding - Mailing list pgsql-general

From JORGE MALDONADO
Subject WIN1252 vs UTF8 database encoding
Date
Msg-id CAAY=A78phNKCq6gExba9ypqvdqow3y4oFRNzVXhqkisC5u6auw@mail.gmail.com
Whole thread Raw
Responses Re: WIN1252 vs UTF8 database encoding
List pgsql-general
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

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Displaying chat by punished users only to themselves (db fiddle attached)
Next
From: Adrian Klaver
Date:
Subject: Re: WIN1252 vs UTF8 database encoding