Files
kefu/im/.deploy/backend-20260830/migrations/009_repair_utf8_defaults.sql
2026-09-03 08:38:17 +08:00

7 lines
367 B
SQL

-- PowerShell 5 may encode text piped to native executables as the active ANSI
-- code page. Repair the only user-visible non-ASCII integration default for
-- databases initialized by the earlier migration runner.
UPDATE system_configs
SET config_value = CONVERT(0xE6989FE98187E7A4BEE4BAA4 USING utf8mb4)
WHERE config_key = 'sms.sign_name' AND config_value = '????';