Editing Troubleshooting of common Excel errors (section)

=== Resolving "Support 32767 characters in a cell only" Error When Exporting Database Data to Excel Files ===

'''Problem Description'''

When exporting data from database to Excel files, the error message [ERR] Support 32767 characters in a cell only appears.

'''Root Cause'''

Excel cells have a maximum capacity of 32,767 characters <ref>[https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Microsoft Support]</ref>. When a field in a database record contains content exceeding this limit, the [ERR] Support 32767 characters in a cell only error message occurs.

'''Solution'''

This can be resolved through the following two approaches <ref>[https://errerrors.blogspot.com/2023/07/fix-the-error-support-32767-characters-in-a-cell-only-on-navicat.html 解決 Navicat 匯出 Excel 檔案遇到 [ERR] Support 32767 characters in a cell only 錯誤訊息]</ref>:
1. Use file formats that do not have the 32767 character limitation
2. Use the SUBSTRING function to reduce content length

MySQL Query That Causes the Error
<pre>
SELECT 
  title, 
  content
FROM my_column
</pre>

Corrected MySQL Query
<pre>
SELECT 
  title, 
  SUBSTRING(content, 1, 32767) AS content
FROM my_column
</pre>