# `Sp_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 `Sp_Gb2Big_ChineseToBig`'`._

## Narrative

**Business context:** Localisation backfill. Sweeps all UI-label columns across `gdsmodule`, `gdsconfigformmaster`, `gdsconfigcharmaster`, `gdsconfigformslave`, `gdsformconst`, `gdsjurisdiction` and converts each `sChinese*` (Simplified GB) value into its Traditional-Chinese (Big5) counterpart in the parallel `sBig5*` column via `F_Gb2Big(sChinese, 1)`. Drives the Traditional-Chinese UI swap for HK/TW deployments without any per-row trigger.

**What it does:** Bulk UPDATE: `gdsmodule.sBig5/sBig5Depart/sBig5UnMemo/sBig5WorkFruit`, `gdsconfigformmaster.sBig5`, `gdsconfigcharmaster.sBig5`, `gdsformconst.sBig5`, `gdsjurisdiction.sBig5`. The slave-column table `gdsconfigformslave` is the big one — it pages through `iIncrement DESC` 1,000 rows at a time using a cursor; for each `sId` it sets `sBig5 = F_Gb2Big(sChinese, 1)` and `sBig5DropDown = F_Gb2Big(sChineseDropDown, 1)`. No parameters; affects the whole tenant.

**Invocation:** Status: appears orphaned. No caller found in any channel — no `gdsmodule` hook, no `gdsconfigformmaster` reference, no other proc CALLs it, no xly-src Java grep hit (only the install scripts `script/标版/30100101/Sp_Gb2Big_ChineseToBig.sql` and the underlying `F_Gb2Big` / `Fun_Gb2Big_ChineseToBig` definitions appear). Intended as a manual DBA tool run after Simplified-Chinese metadata edits, before deploying a Big5 tenant. `F_Gb2Big` itself is referenced once in `GdsconfigformMapper.xml` for column-comment formatting — that's a column-level reference, not a call into this proc.
