gb18030_2022

ivorysql : Support GB18030-2022 and UTF-8 conversion

Overview

Packages

Source

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install ivorysql;		# install via package name, for the active PG version
pig install gb18030_2022;		# install by extension name, for the current active PG version

pig install gb18030_2022 -v 18;   # install for PG 18

Create this extension with:

CREATE EXTENSION gb18030_2022;

Usage

gb18030_2022: Support GB18030-2022 and UTF-8 conversion

The gb18030_2022 extension provides conversion support between the GB18030-2022 Chinese national character encoding standard and UTF-8.

Enabling

CREATE EXTENSION gb18030_2022;

Overview

GB18030-2022 is the updated Chinese national standard for character encoding, superseding GB18030-2005. This extension enables PostgreSQL to properly handle conversion between GB18030-2022 encoded data and UTF-8.

Key Features

• Full support for GB18030-2022 character encoding standard
• Bidirectional conversion between GB18030-2022 and UTF-8
• Updated character mappings per the 2022 revision of the standard
• Handles all CJK Unified Ideographs, including Extension blocks

This extension is part of the IvorySQL project and is primarily useful for applications that need to process Chinese text data encoded in the GB18030-2022 standard.