Forum Discussion
Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
Is encoding SQL_ASCII with Collation en_US.1252 supported in Azure FlexibleServer PostgreSQL? CREATE DATABASE databaseforme WITH ENCODING = 'SQL_ASCII' LC_COLLATE = 'en_US.1252' LC_CTYPE = '...
I created the database using the encodings UTF8, then I created the Collation 1252 in the database. Internal customer tested read/write with the ASCII fat client and works without issues
CREATE DATABASE "test-dev-002"
WITH
TEMPLATE = template0
ENCODING = 'UTF8'
LC_COLLATE = 'C'
LC_CTYPE = 'C'
LOCALE_PROVIDER = 'libc'
IS_TEMPLATE = False;
CREATE COLLATION "English_United States.1252" (provider = icu, locale = "English_United States.1252");
highlighted: library C and Template0 needed for creating the database
luistorres It's great to hear that your internal testing with the ASCII fat client went smoothly after creating the database using UTF8 encoding and subsequently adding the 1252 collation.
If you encounter any further challenges or need additional assistance, please do not hesitate to contact me.