topic Re: What is BINARY data type of Oracle Source Endpoint in User Guide ? in Qlik Replicate

What is BINARY data type of Oracle Source Endpoint in User Guide ?

khchoy — Wed, 22 May 2024 03:13:52 GMT

Hi,

In Qlik Replicate User Guide and Online Help, Oracle source endpoint supported data types include "BINARY".

What is "BINARY" ? I checked several versions , all included. So I checked Oracle manual in Oracle site, I can't find "BINARY" data type. Is it wrong information ? if it is mistake , why it is not fixed ?

Regards,

KwangHo

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

ltf — Wed, 22 May 2024 02:04:26 GMT

Hi @khchoy,

Thank you for contacting us through Qlik community.

The Oracle database for Qlik Replicate supports most Oracle data types, in which BINARY is one of them using Qlik Replicate and the default mapping to Qlik Replicate data types. Qlik Replicate converts source data to its own data type. For data that Replicate cannot convert, it returns an error.

For example, when replicating data from an Oracle source endpoint to a Microsoft SQL Server target endpoint, Replicate first converts the Oracle data type BINARY to the Replicate data type BYTES. BYTES maps to the Microsoft SQL Server data type VARBINARY (Length)

More info: https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Endpoints/att_rep_data_types.htm

Let us know if you have any further questions.

Best Regards,
Faariha

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

Yadunandan — Wed, 22 May 2024 02:22:54 GMT

Hello KwangHo,

The BINARY type is similar to CHAR, except that they store binary strings rather than nonbinary strings. That is, they store byte strings rather than character strings. This means they have the BINARY character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values.

You can refer to BINARY DATATYPE for more information.

Regards,
Yadunandan

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

khchoy — Wed, 22 May 2024 03:51:57 GMT

Is "BINARY" data type built in Oracle Data type ? BINARY DATATYPE link is MySQL Manual.

I can't find "BINARY" data type in Oracle database. In Replicate User Guide and Help , Oracle database have "BINARY" data type. But I think "BINARY" data type is Oracle MySQL datatype.

(Ref: ChatGPT answer : Oracle does not have a built-in "BINARY" data type. However, Oracle does have data types like BLOB (Binary Large Object) and RAW which can be used to store binary data. )

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

Heinvandenheuvel — Wed, 22 May 2024 03:59:37 GMT

This does look like a mistake.

The intended is to talk about chars which are not interpreted according to some NLS rules, but what is te point if the datatype does not actually exist and thus cannot be 'detected' by Replicate.

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

khchoy — Wed, 22 May 2024 04:15:29 GMT

I think some mistake in Manual must fixed next version.

Re: What is BINARY data type of Oracle Source Endpoint in User Guide ?

DesmondWOO — Wed, 22 May 2024 05:00:24 GMT

Hi @khchoy ,

Agree with @Heinvandenheuvel , I can't find BINARY data type in the Oracle Built-In Data Type Summary.

Please create a support ticket for this issue.

Thanks,
Desmond