gb18030_2022

Overview

from contrib/gb18030_2022/gb18030_2022.control and package metadata

Version

Install

You can install ivorysql directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install ivorysql;          # Install for current active PG version

pig ext install -y ivorysql -v 18  # PG 18

dnf install -y ivorysql5       # PG 18

apt install -y ivorysql-5   # PG 18

Create Extension:

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.