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