将oracle迁移到PostgreSQL无效字节序列以进行编码"UTF8":0x00 [英] migration oracle to postgresql invalid byte sequence for encoding "UTF8": 0x00

问题描述

我正在将应用程序从oracle迁移到postgresql.在我已经迁移的功能之一中，我将数据从另一个表中的几个表复制到另一个oracle数据库(oracle中的db链接，postgresql中的oracle_fdw扩展名)到postgresql db中的本地表中.但是，我遇到下一个错误:

Im migrating an application from oracle to postgresql. In one of the functions that I already migrated I copy data from a different oracle db (db link in oracle, oracle_fdw extension in postgresql) from a few tables into a local table in my postgresql db. However, I`m getting the next error :

invalid byte sequence for encoding "UTF8": 0x00

我在这个论坛上看到有些人遇到这种问题，但是他们没有尝试直接从远程数据库(他们从转储或csv ..加载的数据)中复制数据.

I saw that some people had this kind of issue in this forum but they didnt try to copy the data directly from a remote database (they loaded data from a dump or from a csv..).

有些想法我该怎么办?

推荐答案

PostgreSQL不允许使用零".字符串中的字符.

PostgreSQL does not allow the “zero” character in character strings.

您必须先清理Oracle数据，然后才能从PostgreSQL中检索它们.

You'll have to sanitize the Oracle data before you can retrieve them from PostgreSQL.

这篇关于将oracle迁移到PostgreSQL无效字节序列以进行编码"UTF8":0x00的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！