Workplace by Facebook Import Error "uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x93\xA2' for column 'name' at row 1"
Last Updated:
Overview
Workplace by Facebook import fails with the following error:
An error occurred during import
null; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x93\xA2' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x93\xA2' for column 'name' at row 1"
Applies To
- Workplace by Facebook
- Import
Cause
The error is related to the special characters, including emojis, mathematical symbols, and/or foreign characters present in the groups and/or usernames being imported from the Workplace.
Solution
-
Verify that all the users and/or groups trying to be imported from Workplace do not have special characters, including emojis, mathematical symbols, and/or foreign characters, in their names.
-
Once the groups and/or username was corrected (i.e., remove any unsupported characters), attempt the import again.
