# `Fun_Gb2Big_ChineseToBig` (function)


- **Type:** FUNCTION
- **Returns:** `varchar(4000)`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `Fun_Gb2Big_ChineseToBig`'`._

## Narrative

**Business context:** Bulk simplified-Chinese → Traditional-Chinese (Big5) refresh for the metadata catalog. Every UI label across `gdsmodule`, `gdsconfigformmaster`, `gdsconfigcharmaster`, `gdsconfigformslave`, `gdsformconst`, `gdsjurisdiction` is shipped in `sChinese` (simplified); the `sBig5` columns next to them hold the traditional rendering shown to Big5 tenants. This function re-derives `sBig5` from `sChinese` in one pass by piping every label through the lower-level `F_Gb2Big` per-string converter.

**What it does:** runs an unconditional `UPDATE … SET sBig5 = F_Gb2Big(sChinese, 1)` on each of those six tables (plus the related `sBig5Depart`, `sBig5UnMemo`, `sBig5WorkFruit` on `gdsmodule` and `sBig5DropDown` on the const slave rows). Returns the empty string. Note: a sibling **procedure** of the same name (~2.2K body) does this in 1000-row paginated batches via cursor — likely the safer alternative on large catalogs.

**Invocation:** Status: appears orphaned. No caller found in any channel (form-master sSqlStr, gdsmodule hooks, other routines, exhaustive xly-src grep, dynamic-dispatch search) — candidate for maintainer audit. Typically run manually after deploying a new metadata catalog.
