How to debug the error related to Inserting the data to record

Data Service
1

Hello,

i tried to insert the data to backendless database, i’m getting this error.

14:56:17 IMPORT_DATA Error inserting row to table TestData com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: ‘\xF0\x9F\x8E\xB5MU…’ for column ‘Title.124F938E-BDC7-355B-FF31-1E73089FB600’ at row 1
Here, i’m able to import the record successfully, but i’m not able to track which record has issue. how to findout?
How can i search, this record Title.124F938E-BDC7-355B-FF31-1E73089FB600 in the database?. Any help please

2

Hi @ramesh,
Seems like '\xF0\x9F\x8E\xB5MU is some unicode string, try to remove this record from export .csv files and try again.
Artur

3

Hello, i’m not getting this string in my CSV file, i wont be able to search this string in my file.