+ Start a Discussion
parag r 4parag r 4 

UTF8 Issue while importing data to salesforce using jitterbit data loader

We have created mysql view and using Jitterbit cloud data loader (v: 8.16.13.1) to load the view data to saleforce objects.
 We  have UTf8 special chatacters for eg:  .Ã,®,Ø,ÿ in the field.

When We do upsert for object, upsert fails and gives the following error.
The operation "Upsert 1" failed.
Error: Failed to read JDBC source.
Database Error: Incorrect string value: '\x00\x84\x00\x2E\x00\x22...' for column '_input_string' at row 1

SQL: SELECT ... ....FROM `mysqlview_for_salesforce`
Fatal Error
Transformation failed.

Thanks for any help/suggestions in advance