admin管理员组

文章数量:1021946

In PDI Spoon, I imported data from Excel spreadsheet and exported into the Database. Which then resulted the error of

Conversion from collation utf8mb4_0900_ai_ci into latin1_swedish_ci impossible for parameter.

I've tried using Modified JavaScript Value step to remove non-ASCII characters

field_name = field_name.toString().replace(/[^\x00-\x7F]/g, "");

I have also tried to use the Select Value step to change the encoding to ISO-8859-1

Both doesn't work and shows the same error. Any other methods or solutions that I can implement within PDI Spoon (by not configuring the settings of DB)?

My current database collation settings are as below

  • Driver: MySQL
  • Engine InnoDB
  • Default Charset: utf8mb4
  • Default Collation: utf8mb4_0900_ai_ci

However, all tables in the database have the Default Charset of latin1. Which makes all varchar encoding as latin1.

In PDI Spoon, I imported data from Excel spreadsheet and exported into the Database. Which then resulted the error of

Conversion from collation utf8mb4_0900_ai_ci into latin1_swedish_ci impossible for parameter.

I've tried using Modified JavaScript Value step to remove non-ASCII characters

field_name = field_name.toString().replace(/[^\x00-\x7F]/g, "");

I have also tried to use the Select Value step to change the encoding to ISO-8859-1

Both doesn't work and shows the same error. Any other methods or solutions that I can implement within PDI Spoon (by not configuring the settings of DB)?

My current database collation settings are as below

  • Driver: MySQL
  • Engine InnoDB
  • Default Charset: utf8mb4
  • Default Collation: utf8mb4_0900_ai_ci

However, all tables in the database have the Default Charset of latin1. Which makes all varchar encoding as latin1.

本文标签：

版权声明：本文标题：pentaho - PDI - Spoon, Error: Conversion from collation utf8mb4_0900_ai_ci into latin1_swedish_ci impossible for parameter using 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745578689a2157178.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。