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

[khchoy]

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

[ltf]

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_typ...

Let us know if you have any further questions.

Best Regards,
Faariha

[Yadunandan]

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

[khchoy]

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. )

[Heinvandenheuvel]

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.

[khchoy]

I think some mistake in Manual must fixed next version. 

[DesmondWOO]

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