使用Kettle 进行Oracle数据迁移时处理编码转换

「爱情、让人受尽委屈。」 2022-02-16 10:18 449阅读 0赞

Oracle客户端编码：

*  执行：SELECT Userenv('language') FROM dual; 
 *  结果：AMERICAN\_AMERICA.US7ASCII

Oracle服务端编码:

执行：SELECT \* FROM Nls\_Database\_Parameters;

结果：

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>参数</td> 
   <td>编码</td> 
  </tr> 
  <tr> 
   <td>NLS_CHARACTERSET</td> 
   <td><span style="color:#f33b45;">US7ASCII</span></td> 
  </tr> 
 </tbody> 
</table>

直接进行表对表传输会出现乱码问题

![20190422104640326.png][]

解决方式：

1.  数据源允许简易转换
2.  中间加两个字段的选择，进行编码转化

![20190422105058943.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 3][]

[20190422104640326.png]: /images/20220216/cc4ab24d27fe45528f8e91864204bc6c.png
[20190422105058943.png]: /images/20220216/888f8dcf6b8b4e418e2994f98ea5e33b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70]: /images/20220216/071923e066c042f080e616be52b6af76.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 1]: /images/20220216/df7a553507264d1a8d05cd514816f8c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 2]: /images/20220216/388f55484dc74e17b7e8e46315df053a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ltMDEyMTM_size_16_color_FFFFFF_t_70 3]: /images/20220216/25e6f231003944a3af6a4d94c7cc1f5d.png