This article provides a solution for an SQL exception that occurs during user and group imports from various applications. The import fails with the following error message:
uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x98\x81\xF0\x9F...' for column 'description' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x81\xF0\x9F...' for column 'description' at row 1
- User Imports
- Group Imports
- Microsoft Office 365
This error occurs when unsupported special characters (such as emojis, mathematical symbols, or foreign characters) are present in the data being imported. These characters may be located in various attributes for users or groups, including fields such as group names or descriptions.
To resolve this error, inspect the user and group data in the source application. Verify that no unsupported special characters are present in any user or group attributes, including fields such as group names and descriptions. Remove any such characters before running the import again.
A list of supported characters is available in the Okta documentation.
