# `Fun_Gb2Big_ChineseToBig` (procedure)


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

_No parameters._

## Body

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

## Narrative

**Business context:** 繁體中文本地化 — paginated rebuild of the Big5 (traditional-Chinese) label cache on `gdsconfigformslave`. For deployments serving Hong Kong / Taiwan / Macau where the UI runs in Big5, every simplified-Chinese caption needs a Big5 twin in the `sBig5*` columns; this procedure refreshes them in 1000-row batches via cursor, calling `F_Gb2Big(sChinese, 1)` per row.

**What it does:** Counts `gdsconfigformslave`, derives `p_sumPage = ceil(count/1000)`, opens a cursor on each page ordered by `iIncrement DESC`, and per row updates `sBig5 = F_Gb2Big(sChinese,1)` plus — when `sDropDownType='const'` and `sChineseDropDown` contains a `{` — `sBig5DropDown` as well. Sibling table refreshes (`gdsmodule`, `gdsconfigformmaster`, `gdsformconst`, `gdsjurisdiction`) are commented out; the live function variant `Fun_Gb2Big_ChineseToBig()` performs those unpaginated.

**Invocation:** Status: appears orphaned in normal operation. No form-master, gdsmodule hook, routine caller, or xly-src `CALL`. The companion file `xly-src/script/标版/30000101/Fun_Gb2Big_ChineseToBig.sql` defines only the FUNCTION variant; the procedure is a paginated re-implementation kept as a DBA tool. The pagination helps when `gdsconfigformslave` is too large for a single `UPDATE` to run within memory/lock budgets.
