SQLPage 为什么不支持中文。- character encoding issue: invalid utf-8 sequence

[yx3016]

SQL 语句中如果包含中文，就会报错。

我尝试将 index.sql 文件另存为 utf - 8 的格式，也报错。

---

If the SQL statement contains Chinese characters, an error will be reported. I tried saving the index.sql file as UTF-8, but it also reported an error.

*edit by @lovasoa * : added translation

[lovasoa]

中文解答

如何在常用编辑器中保存为 UTF-8

1. VS Code

   • 打开文件
   • 右下角状态栏找到编码（例如 "UTF-8" 或 "GBK"）
   • 点击 → 选择 “另存为编码” → 选择 “UTF-8”

2. Sublime Text

   • 打开文件
   • 点击 File → Save with Encoding → UTF-8

3. Notepad++

   • 打开文件
   • 菜单栏选择 编码 → 转换为 UTF-8 无 BOM

4. Windows 记事本

   • 打开文件
   • 点击 文件 → 另存为
   • 在 编码 下拉框选择 UTF-8

如何检查文件当前的实际编码

• VS Code：右下角状态栏会直接显示当前编码。

• Notepad++：菜单栏 编码 → 编码格式 会显示当前编码。

• Linux/Mac 终端：

  file -i index.sql

  输出会类似：

  index.sql: text/plain; charset=gb18030
  

• Windows PowerShell：

  Get-Content index.sql -Encoding Byte | % { $_ }

  或者用 chcp 查看当前代码页。

---

English Answer

How to save as UTF-8 in popular text editors

1. VS Code

   • Open the file
   • Look at the bottom-right status bar for encoding (e.g., "UTF-8" or "GBK")
   • Click → Select "Save with Encoding" → choose "UTF-8"

2. Sublime Text

   • Open the file
   • Go to File → Save with Encoding → UTF-8

3. Notepad++

   • Open the file
   • Go to Encoding → Convert to UTF-8 (without BOM)

4. Windows Notepad

   • Open the file
   • Go to File → Save As
   • Choose UTF-8 in the encoding dropdown

How to check the file's actual encoding

• VS Code: Bottom-right status bar shows current encoding.

• Notepad++: Menu Encoding shows current format.

• Linux/Mac Terminal:

  file -i index.sql

  Example output:

  index.sql: text/plain; charset=gb18030
  

• Windows PowerShell:

  Get-Content index.sql -Encoding Byte | % { $_ }

  Or check the current code page via chcp.

If your index.sql is actually in GBK or GB2312, you'll see the error from your screenshot above.

[yx3016]

非常感谢！ 之前用 windows 记事本，另存过。但是不起作用， 根据你的提示，用vs code 重新编码 ，可以了。 Koala

[lovasoa]

You are welcome ! The next version of SQLPage will have better error messages when the file encoding is incorrect.