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 PROCEDUREFunGb2Big_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.