access-module-encoding
检查Access/VBA导出模块(.bas/.cls)及相关文件的编码一致性和mojibake风险,并修复常见的mojibake。当要求检查编码/编码问题、验证 UTF-8 与 ANSI、修复 mojibake 或在导入 Access 之前检测 BOM/UTF-16 问题时使用。
📖 中文导读:检查Access/VBA导出模块(.bas/.cls)及相关文件的编码一致性和mojibake风险,并修复常见的mojibake。当要求检查编码/编码问题、验证 UTF-8 与 ANSI、修复 mojibake 或在导入 Access 之前检测 BOM/UTF-16 问题时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: access-module-encoding description: Check encoding consistency and mojibake risks for Access/VBA exported modules (.bas/.cls) and related files, and fix common mojibake. Use when asked to review codificacion/encoding issues, to verify UTF-8 vs ANSI, to fix mojibake, or to detect BOM/UTF-16 problems before importing into Access.
Access Module Encoding
Quick use
Check encodings:
python scripts/check_access_module_encoding.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls
python scripts/check_access_module_encoding.py path\to\File.bas path\to\File.cls
python scripts/check_access_module_encoding.py --strict
Fix mojibake (dry-run by default):
python scripts/fix_access_mojibake.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls
python scripts/fix_access_mojibake.py path\to\File.bas --apply --backup
Fix mojibake with built-in Spanish defaults:
python scripts/fix_access_mojibake.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls --spanish-defaults --apply --backup
Fix mojibake with explicit replacements for \ufffd (lossy):
python scripts/fix_access_mojibake.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls --map path\to\mojibake_map.json --fix-map --apply --backup
Normalize to UTF-8 no BOM:
python scripts/normalize_access_module_encoding.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls
python scripts/normalize_access_module_encoding.py path\to\File.bas --dry-run
python scripts/normalize_access_module_encoding.py --root C:\Proyectos\gestion-proyectos --extensions .bas .cls --backup
Interpret results
- ascii-only: safe everywhere.
- utf8: UTF-8 without BOM.
- utf8-bom: UTF-8 with BOM (risky for Access import).
- ansi-cp1252: typical Access export.
- utf16-le/utf16-be/binary: treat as problems.
Normalize notes
- Writes in place; use --dry-run to preview or --backup to keep .bak copies.
- Use --strict to return exit code 1 if a file cannot be converted.
Mojibake notes
- The utf8-in-cp1252 repair is reversible and safe when sequences like \u00c3 or \u00c2 appear.
- Use --spanish-defaults for common Spanish words and EnumSiNo.S\u00ed patterns.
- The replacement character \ufffd is lossy; use --map with explicit replacements if you want to fix it.