Amazon Aurora PostgreSQL reference - Amazon Aurora

Amazon Aurora PostgreSQL reference

In the following topics, you can find information about collations, functions, parameters, and wait events in Amazon Aurora PostgreSQL.

Aurora PostgreSQL collations for EBCDIC and other mainframe migrations

Migrating mainframe applications to new platforms such as AWS ideally preserves application behavior. To preserve application behavior on a new platform exactly as it was on the mainframe requires that migrated data be collated using the same collation and sorting rules. For example, many Db2 migration solutions shift null values to u0180 (Unicode position 0180), so these collations sort u0180 first. This is one example of how collations can vary from their mainframe source and why it's necessary to choose a collation that better maps to the original EBCDIC collation.

Aurora PostgreSQL 14.3 and higher versions provide many ICU and EBCDIC collations to support such migration to AWS using the AWS Mainframe Modernization service. To learn more about this service, see What is AWS Mainframe Modernization?

In the following table, you can find Aurora PostgreSQL–provided collations. These collations follow EBCDIC rules and ensure that mainframe applications function the same on AWS as they did in the mainframe environment. The collation name includes the relevant code page, (cpnnnn), so that you can choose the appropriate collation for your mainframe source. For example, use en-US-cp037-x-icu for to achieve the collation behavior for EBCDIC data that originated from a mainframe application that used code page 037.

EBCDIC collations AWS Blu Age collations AWS Micro Focus collations

da-DK-cp1142-x-icu

da-DK-cp1142b-x-icu

da-DK-cp1142m-x-icu

da-DK-cp277-x-icu

da-DK-cp277b-x-icu

de-DE-cp1141-x-icu

de-DE-cp1141b-x-icu

de-DE-cp1141m-x-icu

de-DE-cp273-x-icu

de-DE-cp273b-x-icu

en-GB-cp1146-x-icu

en-GB-cp1146b-x-icu

en-GB-cp1146m-x-icu

en-GB-cp285-x-icu

en-GB-cp285b-x-icu

en-US-cp037-x-icu

en-US-cp037b-x-icu

en-US-cp1140-x-icu

en-US-cp1140b-x-icu

en-US-cp1140m-x-icu

es-ES-cp1145-x-icu

es-ES-cp1145b-x-icu

es-ES-cp1145m-x-icu

es-ES-cp284-x-icu

es-ES-cp284b-x-icu

fi-FI-cp1143-x-icu

fi-FI-cp1143b-x-icu

fi-FI-cp1143m-x-icu

fi-FI-cp278-x-icu

fi-FI-cp278b-x-icu

fr-FR-cp1147-x-icu

fr-FR-cp1147b-x-icu

fr-FR-cp1147m-x-icu

fr-FR-cp297-x-icu

fr-FR-cp297b-x-icu

it-IT-cp1144-x-icu

it-IT-cp1144b-x-icu

it-IT-cp1144m-x-icu

it-IT-cp280-x-icu

it-IT-cp280b-x-icu

nl-BE-cp1148-x-icu

nl-BE-cp1148b-x-icu

nl-BE-cp1148m-x-icu

nl-BE-cp500-x-icu

nl-BE-cp500b-x-icu

To learn more about AWS Blu Age, see Tutorial: Managed Runtime for AWS Blu Age in the AWS Mainframe Modernization User Guide.

For more information about working with AWS Micro Focus, see Tutorial: Managed Runtime for Micro Focus in the AWS Mainframe Modernization User Guide.

For more information about managing collations in PostgreSQL, see Collation Support in the PostgreSQL documentation.