Error with accents to Run Transformation Kettle Pentaho

Question

I have a problem with accents using pentaho data integration to migrate data from sql server to postgresql but just in some cases increases a one symbol. The data type in Sql Server is type Varchar(MAX) and PostgreSQL is type Text For Example:

Sql Server: CARREOCERÃA
PostgreSQL: CARREOCERÃ?A

Version Pentaho: 7.1.0.0-12

Can you check if it is the encoding : what does say the preview on the SQL-Server input ? — AlainD, Oct 25 '17 at 07:14
If you supply minimal DB scripts (create, insert) and a transformation, I'll have a look at my side. — matthiash, Oct 30 '17 at 12:43

score 0 · Answer 1 · answered Oct 25 '17 at 07:13

You can specify the charset when you define the connection: on the left hand panel click on Option.

These are database properties. For postgres, put charset in the Parameter column and choose the appropriate value from here. For SQL-Server, I couldn't find the doc.

For SQL-Server, according to this question you could set useUnicode=true characterEncoding=UTF-8.

Error with accents to Run Transformation Kettle Pentaho

1 Answers1