Convert type Text in Postgres to VARCHAR in Oracle

vitalf03 — Thu, 28 Sep 2023 14:25:01 GMT

Hi,

Using Qlik Replicate, I am trying to convert a column of type TEXT in Postgres (Source) to VARCHAR in Oracle (destination), but when the transaction occurs this column of type TEXT is registered as NULL on target.

how i do Convert type Text in Postgres to VARCHAR in Oracle?

Re: Convert type Text in Postgres to VARCHAR in Oracle

john_wang — Thu, 28 Sep 2023 16:08:37 GMT

Hello @vitalf03 ,

Thanks for opening the article!

By default, the TEXT data type in PostgreSQL is treat as NCLOB, so far the data type in Oracle will be created as NCLOB. If you want to map it to VARCHAR2, then the straightforward way is changing the data type from NCLOB to STRING(n) in Transform , where n is the maximum length of the TEXT column. The column in Oracle will be created as VARCHAR2(n).

The screen shot:

I'm not very sure why it becomes NULL in your scenarios, please let us know the transformation definition, and if the problem occurs in Full Load, or in CDC, or in both of Full Load and CDC.

BTW, we have other options eg:

1- use source_lookup

2- use PostgreSQL parameters TextAsLongVarchar to control the data type mapping

Hope this helps.

Regards,

John.

topic Re: Convert type Text in Postgres to VARCHAR in Oracle in Qlik Replicate

Convert type Text in Postgres to VARCHAR in Oracle

Re: Convert type Text in Postgres to VARCHAR in Oracle