WIN1252 vs UTF8 database encoding

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: WIN1252 vs UTF8 database encoding
Date: 2022-05-04 21:51:04
Message-ID: CAAY=A78phNKCq6gExba9ypqvdqow3y4oFRNzVXhqkisC5u6auw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-05-04 22:27:03 Re: WIN1252 vs UTF8 database encoding
Previous Message Alexander Farber 2022-05-04 18:36:51 Re: Displaying chat by punished users only to themselves (db fiddle attached)